Hello BW Gurus,
Can any one help me in getting past 12 months average? Do we need to write any code? Currently I am using formula key figure (period1) and text variable (zperiod1)in the Bex to calculate the past 12 months average but for some reason it is giving the wrong values.
I am calculating as follows:
period1 = current month-13;current month-1
zperiod = period1/12
period1 is not giving me the total range value of last 12 months and it is just picking the current month and dividing it by 12. Is there any work around to get this done?
Thanks in Advance,
Liza.