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

How to do calculation based on cumulated values of a Key Figure

Dear Friends,

I have a doubt regarding calculated on key figure on which i have applied the property CUMULATED . For example i have a key figure A as below :

A A(Cumulated) C = A(Cumulated) * 2

1 1 1

2 3 6

3 6 12

4 10 20

The correct output is in C column . But i am get the output as 1 4 6 8 . That is calculation are happening based on the original values of the key figure and not on the cumulated values of the key figure.

Kindly suggest on this.

Thanka & Regards,

Ashutosh Singh

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 27, 2010 at 04:38 AM

    Hi Ashutosh, I guess BEx has some limitations. If you are using sum/aggregation, its does not refer with the standard aggregations for KFs, as these formulas/CKFs can't be used in other calculations with cummulative property as a derived value. However on a sidenote this is possible in Webi calling certain methods. In BEx, a cummulated value is only a visible indexing & is not physically availiable for usage in formulas. Any suggestions are welcome. Thanks!

    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.