Former Member

# Results row calculation between two column result in BEx Report.

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

10|10000 characters needed characters exceeded

### Related questions

• Former Member
Posted on Dec 07, 2005 at 01:28 PM

Hi,

Just use Excel Macro.

Best Regards,

Suan Liono

10|10000 characters needed characters exceeded
• Former Member
Posted on Dec 07, 2005 at 02:06 PM

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.

10|10000 characters needed characters exceeded
• 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