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?