Skip to Content
0
Feb 02, 2020 at 03:40 PM

Problem with member formula and hierarchy

51 Views

Hello experts,

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.

Ale.

Attachments

1.png (17.3 kB)
2.png (25.6 kB)
3.png (12.3 kB)
4.png (29.9 kB)
5.png (33.2 kB)
5.png (40.1 kB)
5.png (40.1 kB)