2918780 - The value of a field is doubled or tripled etc in a report

You wanted to know why the value is not appearing correctly and also want to know how to  get it right.

SAP Business Bydesign

I shall explain with an example data source SRMIX_U01 - Supplier Invoice and Supplier Invoice Exception Analysis, However in this data source you will see that total gross amount value doubled than the actual value appearing in the supplier invoice.

 So firstly follow the details of the KBA: 2918187 - Custom report shows value of a field as # or empty or unexpected value

 SRMIX_U01 is a combined Data Source, based on 3 different data sources.

 Involved data sources:

 > SRMIX_B01 - Exception From Supplier Invoice Root

 > SRMIX_B02 - Exception from Supplier Invoice Item

 > SRM_B03 - Supplier Invoice Header without Exceptions

 Counter represents the number of sources involved. that is explained below

 case 1:

If the Supplier invoice has  3 exceptions  out that one is related to header and two related to item (where item  number appears in the exception).

> SRMIX_B01 - Exception From Supplier Invoice Root ,if  the invoice has such exception then Counter = 1

> SRMIX_B02 - Exception from Supplier Invoice Item, if  the invoice has such exception then Counter = 1

> SRM_B03 - Supplier Invoice Header without exceptions (0)

 Here counter is 2

case 2:

> SRMIX_B01 - Exception From Supplier Invoice Root (0)

> SRMIX_B02 - Exception from Supplier Invoice Item (0)

> SRM_B03 - Supplier Invoice Header without exceptions (Counter = 2)

 Why is the Counter 2 on SRM_B03…

 It appears to take the 'Total Gross Amount' value from each item, so ifthere are two items, so it is taking gross amount from both items, meaning the counter is 2. If there were 3 items, the counter would be 3 etc.

You can see the value for the counter in the data source preview.

 You should create a calculated key figure, with the calculation  as Total Gross Amount  divided by Counter, and add  it to the Data source SRMIX_U01.

• Go to Business Analytics
•  Create Key Figure
•  Data Source: SRMIX_U01
•  Type: Calculated
•  Add Parameters
•  Total Gross Amount (Under Basic Key Figures)
•  DIV (under mathematical tab)
•  Counter
•  Calculate Result as 'Total'

 You can open yoru customized report and then add the key figures Total Gross Amount, Counter and the newly calculated key figure, to check that the new customized key figure is configured correctly.

2918187 - Custom report shows value of a field as # or empty or unexpected value

duubled value, tripled value,  Value multiplies , KBA , SRD-SRM-SI , Supplier Invoicing , Problem