L2-Sprint 2, DEM03 module

Hi,

In L2-Sprint 2, DEM03 module we created few line items and applied some formulaes, after applying formulaes the data is populated for only FY2020 since we have only 2019 actual data we pulled the data from 2019 to 2020 by applying OFFSET function. In DEM03 module, for Baseline forecast line item we applied a formulae 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' after applying only FY2020 data is populated FY2021 is not populated. In this case how to update the data or how to calculate the data FY2021.
Can anyone help me out.

Regards,
Sai.

Captu22re_145280.JPG

Comments

bhatjaved

@Saivamshi You are close to the approach but think you may need help of the system modules where you can highlight the 1st year forecast and bring values from DAT03 which you are referencing now but with IF condition you can use LAG function based on the default forecast which should populate your 2021 data

Aini

I couldn't see forecast volume data for FY2021 too? Anyone can guide on this?

Venki9902

Hi @Saivamshi ,

As per your screenshot I can see you are only giving 1st forecast year data.

Actually write a formula in a such way that if it is forecast year then your formula else you have to give 52 weeks backdata using offset condition.

hope this helps.

regards,

Venkatesh

Quick Links

Recent release news

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…