Results when I have cumulated keyfigure

[Former Member]

Hi!,

I have a query which has one keyfigure, this is a cumulated (atribute cumulated on). But the result line is not the sum of the shown amounts .

Ej: This is what i have now

char 01.2006 | 02.2006 | 03.2006

A amount 10 | 20 | 30

B amount 15 | 30 | 45

Result 25 | 25 | 25

what I expect is the sum of cumulated.

EJ:

char 01.2006 | 02.2006 | 03.2006

A amount 10 | 20 | 30

B amount 15 | 30 | 45

Result 25 | 50 | 75

I would apretiate your help

Thanks

Victoria

[Former Member · Accepted solution]

HI LEON,

go to the setting of key figure in bex properties and make summation of result on

[Former Member · Accepted solution]

Thanks!!

I make “also apply to results” ON in the setting of key figure in bex properties, the overall result is what I expect.

But when I try to set this attribute ( “also apply to results” ) in the properties of the selection/formula of the Key Figure, is blocked. I need to obtain that result leaving the fixed value in the query.

Some help.

Regards

Victoria

[former_member699913]

HI LEON,

Check the following links...

they will definitely help you...

http://help.sap.com/saphelp_nw04/helpdata/en/44/b21f98be886a45a4bb7e123e86e4c2/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/44/b21f98be886a45a4bb7e123e86e4c2/frameset.htm

thanks,

ajay

[Former Member]

What is the setting on the key figure? Change this to have the calculate as summation instead of nothing defined.

Jeff

[Former Member]

Hi Jeff,

In the properties of the key Figure I placed the attribute Cumulated ON (in the calculated single values area) and in the calculate result as.. I placed summation, and the overall result is the same, is not the summation of the cumulated values of keyfigure.

Regards

Victoria