on 08-26-2009 11:37 AM
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.
Nope we can't do that at report level its doesn't work. We need to change it in rsd1.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can create a Formula using the KF : GOD QTY and then change the aggregate ref char 0CALMONTH.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.