Level 2 Sprint 2 - 2.3.10 activity

kasarnikhil958

I have created module DEM03 Demand Forecast with 4 line item Baseline forecast, Growth%, Default Forecast, Initial Demand Forecast in which baseline and initial demand forecast are only available for first forecast year 2020 and for 2021 year it showing blank. 2020 is current year . but next activity of building UX page need baseline and initial demand forecast for 2 year. So where I am doing wrong. please give me solution am I using wrong formula for baseline forecast or anything else . thank you   

RavinderB

Hi

Assuming to did everything correctly before DEM03, it should look like:

 

I would also check your fomulas:
IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE OFFSET(Default Forecast, -52, 0)

'DEM02 Volume Growth Rates by Week'.Growth %[LOOKUP: 'SYS08 SKU Details'.Product Family]

 

Baseline Forecast + Baseline Forecast * Growth Rate %

 

ROUND(Default Forecast, 0, UP, NORMAL)

You may need to debug here if you can't see the relevant data.

Ravinder

kasarnikhil958

thank you,

I got it.

Pravallika

'DEM02 Volume Growth Rates by Week'.'Growth %'[LOOKUP: 'SYS08 SKU Details'.Product Family]

Can u plz help out diz formula in 2.3.10 activity