SAP Knowledge Base Article - Public

2855043 - Is it Possible to Round Numbers on a Composite Query Table on WFA

Symptom

  • Is it Possible to Round Numbers on a Composite Query Table on WFA?
  • Is it possible to remove the numbers after the comma/point?
  • Is it possible to shorten a number? Example: $1000000, we could display in the table $1,0 M?

Environment

  • SAP SuccessFactors Workforce Analytics
  • Composite Query

Resolution

Currently it is not possible to round the numbers or shorten them on the table. It is only possible to select the Format on the calculation block, but not on the query itself. See screenshots below:

Select the option to edit the Format.

2019-10-28_17-51-15.jpg

This screen will show:

2019-10-28_17-09-43.jpg

It is possible to remove to round up and change the format of the valuers by removing the zeros after the dot.

2019-10-28_17-10-19.jpg

Keywords

Composite query - format values - rounded numbers , KBA , LOD-SF-WFA-WA , Workforce Anaytics , Product Enhancement

Product

SAP SuccessFactors Workforce Analytics all versions