I need to take a committed contract amount and forecast it going forward as if the contracts will be renewed for exactly the same amount once the contract expires. Contracts can be month to month, quarterly, annual, or bi-annual. The image below shows a mock-up of committed contracts in green text and how I would need to forecast those amounts going forward (in blue).
How do I accomplish this in Anaplan?
E.g. The $50,000 quarterly contract in Aug 20 will renew in Nov 20 for $50,000, the $300,000 quarterly contract in Sep 20 will renew in Dec 20 for $300,000, and the $33,000,000 annual contract in Aug 20 will renew in Aug 21 for $33,000,000
Oh, got it! I had given up on trying that because I couldn't get around the circular reference error when trying to do Post(itself, driver) but it does work correctly if I hardcode in the numbers and do a nested IF statement which works for me for this use case.