leaf level calculation for weighted average

[Former Member]

I have two measures: "A_PCT" - a percentage value and "B"

The current aggregation function for A_PCT and B is SUM.

How can I achieve, that the following formula is calculated at leaf level (or for each dimension value): A_PCT * B and gets summed up afterwards.

When I write the formula A_PCT*B it is caluclating actually SUM(A_PCT)*SUM(B), which makes no sense because A_PCT is a percentage.

I need that for a weighted average.

I am using WebI 4.0 SP6 btw.

Thanks!

[Former Member · Accepted solution]

Hi Hans,

did you already tried with hierarchical formulas as mentioned in following thread?

http://scn.sap.com/thread/3286510

Best regards,

Victor

[Former Member · Accepted solution]

Hi,

Thanks, but I am not using hierarchy, I have a relational universe.

just to clarify my problem:

in my table I have projects with a percentage % value and a dollar value.

No I have to show the average percentage value for different dimensions (region, country, etc.) But the average percentage value should be weighted by the dollar value. That must happen at the leaf level (for each project) and must be summed up afterwards.

[former_member188911 · Accepted solution]

It looks like you need to force the calculation context, please check the manual  Using functions, formulas and calculations 

http://help.sap.com/businessobject/product_guides/boexir4/en/xi4sp5_ffc_en.pdf 

see pp 21 and  ff

Thanks

Simone