Highlighted
New Contributor

Re: Circular reference with previous value

Hello , 

 

the Previous formula does not work 😕 

Highlighted
Community Boss

Re: Circular reference with previous value

what do you mean ? maybe open a topic

Nathan Rudman, Anaplan Model Builder
Highlighted
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.)

Highlighted
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