Hi,
Some values should be in 'Offset Volumes for 1st Forecast Year' line, but nothing!
Where am I doing wrong?
Thanks,
Mark
The OFFSET function is working with the -52 Volumes. So if you go to FY20 you will see your results.
@Markcol The IF formula you are using refers to the 1st forceast year, which in this case is FY20; if you scroll across to this time period you will see the data. Thank You
Check out the latest Anaplan feature updates and enhancements in our September 2026 official release notes. There you'll find information on: User Experience KPI cards Mobile Zoom and pan KPI Conditional formatting Intelligence CoModeler Analyst Optimizer Disclosure Management Refreshed user interface Anaplan Data…
Please take note of the following changes in our latest 2608 release: Multi-dimensional calculations now require valid rules. As of 2608, the multi-dimensional calculation process no longer runs when invalid rules are present - for example, a rule referencing an invalid member (one that no longer exists in the dimension).…