Skip to Content
0
Former Member
May 17, 2010 at 07:44 AM

Summation on KFG doesn't work properly

31 Views

In my query based on InfoCube I got 3 characteristics:

Planning Date

Date

Planning Level

and one Key figure

Planned amount

For every Planning Level on every Date there can be several plannings done on different Planning Dates. In my query I need to show only the LAST planned amount. I've done it by creating Calculated Key Figure "Last planned Amount" with Exception Aggregation "Last Value" and Reference Characteristic Planning Date. But somehow the query doesn't work the way I need it. I got wrong totals by Date. My totals by Date doesn't sum all forecasts (see picture at http://www.ljplus.ru/img4/s/o/sokol_jasnyj/2---detailed-view.jpg) inculding only those, that are done on last date before the Date. In my query I need 48.573 LTL sum, not the 42.785 LTL