SAP Knowledge Base Article - Public

3132833 - Story report Numeric component measures are fetched in Decimal

Symptom

  • In the Chart Structure components, if we choose Numeric to fetch the Measures count then the values will be in Decimal.
  • How to change decimal or number format in Table widgets

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SuccessFactors HXM Suite
    • Analytics & Reporting (Ad Hoc, YouCalc, ORD)
      • People Analytics (Analytics Cloud for SF)
        • Query Designer - Filter, Calculated Column, Params

Reproducing the Issue

1. Go to the Report Center.
2. Create a new Story.
3. Add Chart Structure Component with Numeric Point.
4. Measures added might fetch the count with decimal points.

Cause

Decimal places format of Measures should be set correctly.

Resolution

1. Open Designer of the impacted component.

2. Select a measure (3 dots) -> Click on 'Format'

3. Change the decimal places to 0 under Formatting.

4. Numeric component measures will be fetched without decimal numbers.


For Charts there is another way to set the format:
1. Select Chart
2. Click Edit
3. Go to Styling by clicking paintbrush icon > Number Format -> set Decimal Places to 0


As for Table widgets:
1. Select the column within the widget and right-click
2. From the options select Table Functions
3. Select Edit Styling
4.  Go to Number Format > Decimal Place > Set it to 0

Keywords

decimal, story, chart, number, point, table decimal, table styling, widget number format, decimal places , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , LOD-SF-ANA-SAC , Stories in People Analytics , How To

Product

SAP SuccessFactors HXM Suite 2105

Attachments

Pasted image.png