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

Key Figure aggregation settings

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 27, 2009 at 04:34 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 27, 2009 at 07:01 AM

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

    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.