Skip to Content
author's profile photo Former Member
Former Member

Bex Report result Calculation (derived from other key figures result)

Hi Expert,

I have requirement in which I have to do calculation on result row in Bex Report. Result of one key figure should display the division result coming from other two key figure

Eg:

Plant Material QTY Unit Value Value L1 P001 1234556 4 550 2354234 P002 1234556 6 345 2452 P003 1234556 23 433 2452 P004 1234556 56 165 545 P005 1234556 2522 565 465 P006 1234556 4565 455 546 Result 7176 328.971 2360694 L2 P009 1234556 500 700 500000 Result 500 1000 500000 Orverall 7676 372.68 2860694

As can see in the middle column (Unit Value)

L1

Result 328.971 = 2360694/7176

L2

Result 1000 = 500000/500

Overall

Result 372.68 =2860694/7676

Like that value I need to display in bex report result row . format will be same. Extra column not needed.


I have tried many ways but I am unable to do.

Please some one help me out .... Or there some note .. regarding this,

Thanks in advance.

Regards,

Manoj Kumar

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on May 15, 2015 at 11:18 AM

    Hi Manoj,

    Just an advice, give a try with SUMCT/SUMGT data functions. Create a formual for each KF with this data function, use it in a CKF/Formula to get final result.

    Regards,

    Vengal.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 15, 2015 at 07:46 AM

    Use formula result = value/QTY in using bex formuals.

    Add a comment
    10|10000 characters needed characters exceeded

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.