SAP Knowledge Base Article - Preview

1195780 - Totals and subtotals are incorrect for weighted average report variable

Symptom

You create a report with measures aggregation set to 'none'. The data provider has multiple contexts resulting in two micro-cubes with the measures residing in one cube.

The report contains a variable called "Average" with a formula similar to the following:

=<MeasureA> * <MeasureB> / sum(<MeasureB>)

This variable returns correct values for the rows of data. However, when applying a sum on the "Average" report variable, the sum value is incorrect.

How can you resolve this behavior?


Read more...

Product

SAP BusinessObjects Business Intelligence platform 6.1.3

Keywords

20057 , , KBA , BI-BIP , Business intelligence platform , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.