Using Cumulated Values in Queries for Calculations

[Former Member]

Hi,

I have a calculated key figure that cumulates the values of an amount key figure (done using the calculation tab of the key figure in query designer).

Say,

Charactersitic................KeyFigure.................Cumulated Key Figure

AAAAAAAA.................100............................100

BBBBBBBBB..................200............................300

CCCCCCCCC..................240............................540

DDDDDDDDD..................0................................540

EEEEEEEEEE...................-80............................ 460

Now I want to use this cumulated key figure in a further calulcated key figure, say which does

==cumulated value/200.

Ideally the report should look like this,

Charactersitic................KeyFigure.................Cumulated Key Figure..........................New Calculation (Cumulated Key Figure/200)

AAAAAAAA.................100............................100......................................................0.5 (100/200)

BBBBBBBBB..................200............................300.....................................................1.5 (300/200)

CCCCCCCCC..................240............................540......................................................2.7 (540/200)

DDDDDDDDD..................0................................540......................................................2.7 (540/200)

EEEEEEEEEE...................-80............................ 460......................................................2.3 (460/200)

However, the formula uses the original value of the key figure rather than the cumulated value for calculations.

This is inspite of the fact that the forumla I have written does cumulated key figure/200.

Charactersitic................KeyFigure.................Cumulated Key Figure..........................New Calculation (Cumulated Key Figure/200)

AAAAAAAA.................100............................100......................................................0.5 (100/200)

BBBBBBBBB..................200............................300.....................................................1 (200/200)

CCCCCCCCC..................240............................540......................................................1.2 (240/200)

DDDDDDDDD..................0................................540......................................................0 (0/200)

EEEEEEEEEE...................-80............................ 460......................................................-0.4 (-80/200)

How can I fix this issue?

Regards,

Suraj

Edited by: Suraj Shenoy on Feb 25, 2011 11:36 AM

[Former Member]

Hi,

This is cool.

In rows u select the Characterstics

1.0DIST_CHANNEL

2.Then go to columns and Add the key fig as we do in any case

3.Then create a formula say Formula1 and there in calculation tab check the cumulated check box

4. Then create another formula Formula 2 and there u divide the formula 1 with 200

This will suffice u'r requirement

Thanks

Shivani