SAP Knowledge Base Article - Preview

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


SAP SuccessFactors HXM Suite all versions


  • Online Report Designer
  • ORD
  • Calculated Column
  • Data Type
  • If Else Statement
  • Conditional Logic
  • Greater Than and Less Than
  • Cast
, KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Product Enhancement

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.