SAP Knowledge Base Article - Public

2544657 - Balance Key Figure Behavior

Symptom

You are creating a report which you are using the Balance Key Figure, but the report brings the wrong data values in the results.

Cause

The expected behavior for the Balance key figure is to create a proportion between the total number of records of the report, even if they are blank or 0 and between the records that actually display values.

As example, if you create a report and expect to get the sum of all the values using the Balance key figure,  and instead of 153,00d, that would be the sum of all values in this key figure, you get the result 127,00d for it.

The Balance key figure expected behavior is not to sum the values of the records, it creates a proportion on all the registers available including the blank ones, this means that the sum 153,00d corresponds to 100% and accordingly to my calculations, 127,00d corresponds to 83% of the values, if you apply these percentage values to the number of records that the report will bring, we can see that the report brings 32 records for example, that corresponds to a 100% and that 83% correspond to the records that actually have values to display. This means that, when you get the value 127,00d for the result, the key figure is including the blank records in the math.

Resolution

This is the expected behavior for the Balance Key Figure from a mathematical perspective.

Keywords

KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions