Problem with member formula and hierarchy

[Former Member]

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.

[former_member186338 · Accepted solution]

In general, if you have to calculate:

Amount=Price*Q-ty

Use script logic and write result.

Or use badi.

[Former Member]

Excelent Vadim, Thanks, as always.

[Former Member]

Thanks Vadim, I discard the option with member formula, but with local member I have the same problem. Any suggestion?

[former_member186338]

Have to repeat:

Local members are calculated using values you have in the report line

[former_member186338]

"(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)"

7.100 (SUM P) * 1.008 ( SUM Q) = 7.156.800 - Correct per definition of member formula.

It's calculated AFTER parent aggregation!

[former_member186338]

P.S. Local members are calculated using values you have in the report line. No surprise!