⏱️ CurrentMonth in Actuals Formulas
Writing formulas for Actuals just got a lot simpler. The CurrentMonth operator you already use in Budget and Forecast is now available in Actuals too.
✨ What’s new?
We've brought the CurrentMonth operator to Actuals formulas. You can now use time-based conditions (e.g., IF CurrentMonth > Dec25) directly in your historical data, with the same syntax you already know from Versions.
Whether you're adjusting for a data migration, applying seasonal logic like year-end bonuses, or handling one-off anomalies, you can now express it in a single, clean formula.
⚙️ How it works
Previously, applying time-specific logic in Actuals required creating cumbersome "helper" boolean variables. This update removes that friction, allowing for cleaner and more maintainable formulas.
Same as it is available in versions, engine now supports standard chronological operators (IS, =, >, <) for two types of time logic:
- Absolute time: handle historical anomalies or schema changes (e.g.,
IF CurrentMonth > Dec25 THEN...) - Cyclical time: handle seasonality easily (e.g.,
IF CurrentMonth IS Dec THEN...)
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.