Results row calculation between two column result in BEx Report.

[Former Member]

I want to use weighted average method between two keyfigure.

for example consider the following secnario.

CH Kf1 Kf2

A 10 5

B 6 4

C 3 2

Result 19 b]4.21</b>

how 4.21 is ((105)+(64)+(3*2))/total of Kf1(ie 19)

( A value(Kf1Kf2)+ B value (Kf1Kf2) + C Value (Kf1*Kf2))/total value (Kf1) = 4.21

is it possible to achieve the above result for Kf2.

With regards,

Hari

[Former Member]

Create a new Key Figure to be stored in the cube which will be KF3 = KF1*KF2. Then on the front end create a local formula KF4 = KF3/KF1. This should give you the desired result.

Thanks.

[Former Member]

Hello,

I cannot able to use Excel Macro functionality since it is a drill down report and report cells varies based upon the selection parameter.

and also i can't able to use Calculation, since this report contains lot of columns and if i use the formula, one more result column i have to include in all key figures and also business users not able to understand the report....

Is it possible to create a variable structure, for example user is executing for 10 days , the structure should display for only 10 days ans also i create structure for 31 days (ie one month)..

With regards,

Hari

[Former Member]

Hi,

Just use Excel Macro.

Best Regards,

Suan Liono