topic Re: Rolling Sums in App Development

Rolling Sums

monobrotadeb — Thu, 06 Dec 2018 04:24:44 GMT

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 — Thu, 06 Dec 2018 05:17:02 GMT

How is your calculation currently?

monobrotadeb — Thu, 06 Dec 2018 11:32:17 GMT

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