Hi,
I have BEx query have 2 columns: Period and Sum. And report in Crystal Report, based on BEx query. I need to calculate in next column average from: current sum, sum from previous period, sum from previous previous period, sum from next and from next from next.
Example:
Q1_2001 100 --
Q2_2001 120 --
Q3_2001 130 (100120130150150) /5
Q4_2001 150 (120130150150200) /5
Q1_2002 150 (130150150200250) /5
Q2_2002 200 (150150200250300) /5
Q3_2002 250 --
Q4_2002 300 u2013
Formula Workshop have Prev (and Next) functions, but havenu2019t Prev(Prev(kf)). Simple Prev(Prev(kf)) not allowed.
How I can calculate it?
Thank in advance.