SAP Knowledge Base Article - Public

2855070 - Is it possible to set a range on a calculate column?

Symptom

  • Is it possible to set a range on a calculate column?
  • It is required to create a report with a formula IF and ELSE as per example: If (Age between 20 and 25) then 10 else 0. 

Environment

  • SAP SuccessFactors HCM Suite
  • Report Canvas on Advanced reporting query

Resolution

There are two ways to achieve the result:

  • The first is to use the equal and greater than function and the equal and less than function. (These functions will appear after the IF and ELSE condition is put on the query)

    2019-10-28_18-22-17.jpg

  • The second is to select the values individually com the query, however depending on the size of the range it is not advisible.

    2019-10-28_18-37-16.jpg

Keywords

Calculation - Range , KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors HXM Suite all versions