Skip to Content
0
Former Member
Jun 10, 2011 at 07:08 AM

KF calculation

29 Views

Hi All,

I have one KF 0Amount in my Infocube. Data is as below in this KF:

FiscalYP      0Amount

2001000         0
2001001       100
2001002       200
2001003       -100
2001004        500
..
...

2001012       100
2002000       0
2002001       300
2002002       200
...

I need to calculate one KF that will represent the 0Amount for current month - 0Amout for previous month as below

FiscalYP         CALKF
2001001           100  ( 100-0)
2001002            100 ( 200-100)
2001003           -300 ( -100-200)
2001004           600 ( 500-(-100))
...
..

2002000          0 
2002001         300 ( 300-0)
..
..

Problem is users want to report on all the years and fiscal period dynamically. He can either select one year or 5 years or 10 years. Initially I thought i can achieve with the help of customer exits, but I am find hard to make the logic.

Please guide me.

Aman

Edited by: AmanSharma123 on Jun 10, 2011 9:08 AM

Edited by: AmanSharma123 on Jun 10, 2011 9:17 AM