Writing formulas for Actuals just got a lot simpler. The time circular references you already use in Budget and Forecast is now available in Actuals too.

✨ What’s new?

We've extended time-based circular references (already available in Versions) to Actuals formulas. This means you can now define variables that depend on their own previous period value directly in your historical data.

For example, think of a classic cash balance model: your Opening Balance this month equals last month's Closing Balance (Opening Balance = Closing Balance.t-1 + Change in Cash). This pattern is at the core of many financial models, and now works seamlessly in Actuals.

We have also made the This keyword available for Actuals formulas.

⚙️ How it works

The engine now recognizes that a variable referencing its own previous period (e.g., A = B + A.t-1) is valid time-based logic, not a circular error. Your models calculate correctly across periods, just as they do in Versions.

This feature is being rolled out in batches. If you'd like to get access sooner, reach out to your support contact and we'll activate it for you.