My system is SAP BPC 11.1 Standar Model.
We have a problem with member formula, the formula is: P (Price) * Q (Quantity)
When the report expand the hierarchy, is correct:
I have the option to calculate parents in hierarchies:
But when the report compress the hierarchy, is incorrect:
(100 (P) * 5 (Q) ) + (2.000 (P) * 1.000 (Q)) + (5.000 (P) * 3 (Q)) = 2.015.500
The system sum all P and multpliy for all Q:
7.100 (SUM P) * 1.008 ( SUM Q) = 7.156.800 (INCORRECT)
I have test with local member in the report but i have the same problem:
I really appreciate your help.