Circular References - OFFSET

Hi,

I want to create something like the below example, but Anaplan returns circular references.

Could you please give me an idea?

Example

In the above example, I input below formulas

Last month stock = PREVIOUS(Stock)

Consumption = get from different module

Planned Received Amount = OFFSET(Recommended Order Quantity, -1, 0)

Stock = Last month stock - Consumption + Planned Received Amount

Lead time = get from different module

Recommended Order Quantity = IF Stock > OFFSET(Consumption, 1, 0) THEN 0 ELSE OFFSET(Consumption, 1, 0) - Stock

However, I want to change "Planned Received Amount" formula to OFFSET(Recommended Order Quantity, -Lead time, 0)

I can understand if lead time is less than 0 this would be a circular reference, but lead time is always over 0.

Any ideas to resolve this?

Ayumi

Accepted answers

Thank you so much!

as a note, I personally almost never use offset. I prefer the lag and lead, the reason being this way you see immediately what the formula does.

Hide the cards under "Models" section once connected
Hi Is there a way to hide the cards under the "Models" section once connected, as I would like the users to see only the links to the apps? Thank you
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…