CUMULATE circular reference

Options
mshaw
mshaw Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

Hello,

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?

Thanks!

Mike

Tagged:

Comments

  • mshaw
    mshaw Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor

    Hello @ManjunathKN,

    Thank you for your reply.  I tried the adjustment suggested and still ran into the circular reference error.  I do believe that the CUMULATE calculation was the cause.

     

    So, I worked an IF statement to do the cumulation instead, and it appears to be working.

     

    Thanks again for taking the time to look at this with me.

    Thake care,

    Mike

Categories