Author: Andrew Tye is a Certified Master Anaplanner and Technical Lead at Aviva.
In this 'How I Built It' video I go through the steps I followed to resolve a circular reference issue in a time series cash-flow module using LAG and strict.
Often in modeling you're trying to achieve something that is easy to achieve within Excel and a workaround is needed to get the same end result within Anaplan but that can be easily explained.
One key takeaway when trying to resolve a circular reference is to remove the onward calculation links and only reintroduce once you believe the issue has been resolved to prevent the dreaded toaster time, which even in a DEV model can be quite time consuming.
Check it out and leave a comment with questions!