CUMULATE circular reference


There are similar posts on this topic, but none of the solutions seem to work.

I am trying to create an inventory calculation that allows the user to delay/push production to subsequent periods.  Then, the total production that has been pushed will be produced at one time.

CUMULATE is currently used to aggregate the production amounts to be pushed and creating a circular reference when trying to pull in the cumulate amount from the prior period.  Since it is the prior period, it should not be circular.

I have tried LAG in strict mode and PREVIOUS, and both result in circular reference error.

The LAG function works for “~Production not pushed”.  So, I believe the CUMULATE function is the cause of the error, is there a way around this?



Best Answer


  • Hi 

    As far as i can understand, i see, the reason for circular reference is because of line item " Amount to be pushed to next week" Because it is not strict data (the data is looping). 

    Instead of "IF not Production push then 0 else production needed" Can you try "IF Not Production push then 0 else Lead(Ending inventory,-1, Production Needed, Strict)".