Symptom
-
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.
Read more...
Environment
-
Online Report Designer
-
Advance Reporting
-
Calculated Columns
Product
SAP SuccessFactors HCM Suite all versions
Keywords
-
Online Report Designer
-
ORD
-
Calculated Column
-
Data Type
-
If Else Statement
-
Conditional Logic
-
Greater Than and Less Than
-
Cast
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.