cancel
Showing results for 
Search instead for 
Did you mean: 

leaf level calculation for weighted average

Former Member
0 Kudos

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!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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

Answers (0)