SAP Knowledge Base Article - Public

2339148 - Picklists stored as text can now be treated as a number data type in Calculated Columns in Online Report Designer

Symptom

Picklists stored as text can now be treated as a number data type in Calculated Columns in Online Report Designer

Environment

SAP Successfactors

Online Report Designer

Cause

 

  • Before 1511: The picklist columns can not be used in calculated column, with their raw data type which is number. It was always present as the String , which is the run type data type for such columns.
  • After 1511: Picklist can be treated as a number field when needing to perform a mathematical calculation on a pick list field. 
  • Limitation: The feature is available only for Adhoc Live data.

Resolution

  1. Create a calculated column and add a picklist field which was giving the text value.
  2. Double click on the field and change the Function to "Raw value".
  3. Once you change the Function, the calculated column will show the Numerical value associated with the text field.

1.png

 

2.png

 

Keywords

Online Report Designer Picklist raw data Raw Value , KBA , LOD-SF-WFA , Workforce Analytics & Planning , Product Enhancement

Product

SAP SuccessFactors Workforce Analytics 1511 ; SAP SuccessFactors Workforce Analytics 1602 ; SAP SuccessFactors Workforce Analytics 1605 ; SAP SuccessFactors Workforce Analytics 1608