[Updated] Level 2 Sprint 2 DAT03 Historic Volume

Hello Experts,

On DAT03 Historic Volumes my volume line item don't match with the values for FY20 but does match with Offset volumes for Fy20. I used the following formula:

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

also in DEM03 demand forecast pulls only FY20 data not FY21,

the Saved View Name: Detailed Demand Grid UX should display this way:

but what i get is:

DEM03 Demand Forecast:

DAT03 Historic Volume:

SYS01 time settings by Week:

could you please let me know where i need to correct to get the FY21calendar like below:

Please suggest, so that i can proceed and i'm stuck in below chapter:

2.4.7.1 Create Demand Forecast Grid UX saved view

Accepted answers

All comments

LeonardiT

Hi there,

Are you referring to how to create the view to compare first 4 weeks in FY20 and first 4 weeks in FY21 like in the view you referenced? Or are you referring to where to find FY21?

You can do a quick search to find FY21.

Try to leverage on right click - Show/Hide to create such view.

Hope that helps.

robin80son

Thanks, i tried to do that, but would like to know if this is mentioned somewhere in the lesson and did i miss it and would this also be related to any of the time range that i missed to set.

Also the SKU list displaying on the left are huge in number when compared to the screenshot in lesson.

LeonardiT

Hi there,

I believe the screenshot is just to compare at a specific intersection of data to confirm that your formula and result are on the right track. The view is not necessarily needed for the rest of the training. As mentioned, you should try to leverage on the search, show/hide to achieve the same result as the screen. Screenshot 2021-06-23 at 4.36.53 PM.png Screenshot 2021-06-23 at 4.37.13 PM.png

laxmitater

mine is not matching with what it should be and also i am not getting figures in blue.

it should be like this

please help

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…