About jdolich

+1 Kuddo for this question.  It's one that I spent a lot of time with when I first started building planning models for merchandis planning (retail industry).   Quick answer: There's no easy way to solve your problem using Anaplan unless there is an underlying equation that can be defined.  I've not had much luck with trying to find optimal solutions.    Longer answer: I couldn't tell precisely what you were trying to accomplish but it looked like you are discounting loans and FCF across time which means there's an underlying equation.  Below is a job aid I created for our company that helps explain the different kinds of circular references: Algebraic - Same number of equations as unknowns. Anaplan can handle great. Circular - Multiple editable line items for same equation.  Anaplan is okay, but you will need to add a lot of line items. Operations Research (optimal solves) - Anaplan not so great for these. Here's a handy diagram to help explain these three. ... View more

+1 Kudo.  Thanks for this.  I keep forgetting we can export the blueprint to Excel. ... View more

+1 Kudo.  Thanks for this.  I wrote up a job aid that is very similar for those that want to "save-off" their decisions (See attached).  In the retail industry we use this for saving an original plan, last projection, etc...  YOu might also consider adding an "action" to automate this process! ... View more

Brilliant!  Thank you.  I was wondering if this could be done. ... View more