2.3.9.2 Update Historic Volumes for Baseline Forecast_i am not able to get data

Hi,

I have used below offset formula.

IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0

I am getting all zeros also my volume line item data got blank. At first I was able to see data. But now both the line items showing data as 0.

Could anyone please help me. refer attached screenshots. Also please elaborate how we have used offset function in formula.

Thanks in Advance.

Comments

Two observations.

The offset is 52 weeks so you won't see anything 2019. Scroll to 20220 to see the values.
Your "Volumes" line item is empty. You will need to import the data before the Offset line item will work.

Thanks..Yes values are there in 2020.

June 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our June 2025 official release notes. The information below offers supplemental information to that post. Security and administration New 'Application Owner' security role Tenant administrations can assign the Application Owner role to users in their tenant.…
Register for our July 30 platform release webinar!
Anaplan's next quarterly platform release webinar will be held July 30, 2025 at 8 a.m. Pacific Time. During this session, we will explore the latest features so you can optimize your Anaplan experience. Our expert-led session will equip you with a practical guide and live demonstrations to help you get the most out of new…