Rolling Sums

[monobrotadeb]

Hello,

I have the below scenario where I am trying to achieve three things

Things I need to do

1) Rolling sum from the first ship date till the current month

2) Rolling sun from the first ship date till the current month -1

3) Rolling sun from the first ship date till the current month -2

4) Rolling sum of 6 months till Current month-1

an example file is attached.

Things I am doing,

Using Rangesum I get all Rolling sums of any 'n' months, however I am not sure how to exclude the current month in the calculation

Thank you for all the help you could provide in advance.

Deb

[Anil_Babu_Samineni]

How is your calculation currently?

[monobrotadeb]

Hi,

For

1) Rolling sum from the first ship date till the current month, I am doing

Sum( {<[ Ship Yr-Mth1] =,[Ship Yr-Mth2] =, [Ship Yr-Mth]= >} [Ship Count])

Ship Yr-Mth1 and Ship Yr-Mth2 are my other date fields.

I am not able to get 2, 3, and 4.

I can do a rolling 12 for the latest month as 

(Rangesum(below(TOTAL Sum(Ship Count), 0, 12)))

but this is not what I need...

Thanks,

Deb