Skip to Content
0
Former Member
Apr 23, 2009 at 09:33 AM

CR formula

45 Views

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.