cancel
Showing results for 
Search instead for 
Did you mean: 

Key Figure aggregation settings

Former Member
0 Kudos

Hi Guys,

Currently I have one Key Figure, its settings are:

KF: GOD QTY

aggregation: SUM

exception aggregation: LAST VALUE

aggregation ref char: 0CALDAY.

In the report we have 0CALMONTH in column, so we see last value of the month for the key figure (means whatever last day say 31.08.2009) and not the last value posted say 14.08.2009. In the report see value which is posted on 14.08. but using 0calmonth at report.

Can you tell me how do I change the above KF settings to get the last value posted for the KF? I still want to put 0CALMONTH at report level. What will be the changes at exception aggregation and aggregation ref char?

Thanks in advance,

BMW Z4.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Nope we can't do that at report level its doesn't work. We need to change it in rsd1.

Former Member
0 Kudos

You can create a Formula using the KF : GOD QTY and then change the aggregate ref char 0CALMONTH.