I have a report where users enter Calmonth Interval as a selection . For eg . if User gives selection 01.2007 to 03.2007 . Then report Output should be
Material PLant Calmonth Amount-opening Amount-Closing
M1 P1 01.2007 Amount(12.2006) Amount(01.2007)
M1 P1 02.2007 Amount(01.2007) Amount(02.2007)
M1 P1 03.2007 Amount(02.2007) Amount(03.2007)
I have created two RKF's named Amount Closing and Amount-opening . But Problem is I have PLaced Calmonth Variable - 1 in the RKF Amount Opening . THis Figure is not getting calculated correctly and both Opening and Closing is showing the same vales except for the last month ( in this eg . 03.2007 ) .