Movingsum formula

estebanmartinezanavate
New Contributor

Movingsum formula

When using list versions, how do I make the movingsum formula include the forecast output for previous months in the calculation of a given months forecast??
I cant include a "previous" function within the movingsum formula

1 REPLY 1
anand.shekhawat
Super Contributor

Re: Movingsum formula

@estebanmartinezanavate 

This is the constraint that MOVINGSUM has. To achieve this functionality, break your formula in two different line items. In the first line item calculate the PREVIOUS value and in the second calculate the MOVINGSUM of the previous value.

 

~Anand