Year to Date Cumulation

PrevContributor
Previous Contributor

Year to Date Cumulation

Is there a function where I can cumulate an amount but reset it to zero when January is reached in the next year (we are using a 2 year timescale)?

10 REPLIES 10
PrevContributor
Previous Contributor

I find the TIMESUM formula works well for these things. Just have one line item to be the start of each year and then time sum based on that. i.e. if month(start()) = 1 then period(start()) else if month(start()) = 2 then period(start()) - 1 etc then use that as the condition in the timesum.