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


  • 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-ODS , Advanced Reporting , Product Enhancement

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.