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
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.