Skip to Content
0
Former Member
Feb 25, 2011 at 10:35 AM

Using Cumulated Values in Queries for Calculations

23 Views

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