2568599 - Ability to cast data types in calculated columns in Online Report Designer

ORD: Ability to cast data types in calculated columns

ODS/ARB - allow calculated columns to output a 'number' column as 'text'

Condition contains different formula type as the return value.

It would be very helpful if it is possible to utilise a calculated column in the ORD to “cast” a data type.

For example, There is afield “Global Grade” configured in as text field (which is actually containing numeric values).

User wants to do some numeric conditional logic (greater than/less than etc. in If Else Statement) using “Global Grade” field

User may thought maybe they could just use it in a calculated field with a Numeric data type output and it would cast it as numeric, but this doesn’t allow User to compare the numeric values as the field's data type in Text.

Online Report Designer

Advance Reporting

Calculated Columns

Online Report Designer

ORD

Calculated Column

Data Type

If Else Statement

Conditional Logic

Greater Than and Less Than

Cast