I have a circular reference issue that I have not previously seen. The screenshot below shows a relatively simple example of a roll forward calculation where balances are carried forward. The issue I am having is that I would like the 'Out' line item to be dependent on the 'In' line item and simply take data from the 'In' line item and post the negative of it to future periods. I've hard coded the formula to post it 10 periods in the future (days in my example) but if I instead reference any line item to use as the length I get a circular reference, even if the '10' in this example is not dim'd by anything. I get a circular reference issue when using Lag, Offset, Lead, and Profile.
Hi, I have overcome circular references by always taking the data from the source. Try copying the formula from the line item, 'In' directly into the, 'Out' line item. Alternatively, create a section in the module where you pull the source data and reference these line items in all subsequent calculations.
Chris Heathcote Bedford Consulting
Gold Partner and Regional Partner of the Year 2021, EMEA