New Contributor

Re: Circular reference with previous value

Hello , 

 

the Previous formula does not work  

Community Boss

Re: Circular reference with previous value

what do you mean ? maybe open a topic
Nathan Rudman
Anaplan Model Builder
Certified Master Anaplanner

Re: Circular reference with previous value

Is this what you meant for?

If you have the model calendar, you can use 'Previous' formula (as Mr.  @nathan_rudman  said) and avoid circular reference.

 

Previous_Formula.png

 

In original topic, it seems not to use the model calendar, and it is difficult to avoid circular reference, probably.

 

(Sorry, if I've misunderstood your question.)

Community Boss

Re: Circular reference with previous value

you can "transcode" your values onto a daily timescale line item and use the days as your list or artificial steps in your calculation. Being on time you can then use the time functions.
can be a size heavy solution but works
Nathan Rudman
Anaplan Model Builder