Skip to Content
author's profile photo Former Member
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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 07, 2005 at 01:28 PM

    Hi,

    Just use Excel Macro.

    Best Regards,

    Suan Liono

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    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.

    Add a comment
    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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.