Contributor

L2 Sprint 2 - 2.3.10 - Create DEM03 Demand Forecast Module

Hello,

I'm really lost when it comes to formula. I don't understand what to do with formula for Growth Rate % line item?

Greatly appreciate if anyone can give me some guidance.

Thank you!

Candy

2 ACCEPTED SOLUTIONS

Accepted Solutions
Certified Master Anaplanner

Re: L2 Sprint 2 - 2.3.10 - Create DEM03 Demand Forecast Module

Hi @Candy

You can use the below formula to get the Growth Rate%

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

Thanks

Community Boss

Re: L2 Sprint 2 - 2.3.10 - Create DEM03 Demand Forecast Module

As with the MONTHVALUE function you need to map the value from a module dimensioned by the parent of SKU, Product Family,  to a target dimensioned by the child, P3 SKU list.

Therefore, use LOOKUP as per @Sathya message to pull the Growth Rate % as defined by Product Family and assign it each P3 SKU list item.

The mapping relationship will be define in a line item contained in the P3 SKU list details module.

Good luck,

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
5 REPLIES 5
Certified Master Anaplanner

Re: L2 Sprint 2 - 2.3.10 - Create DEM03 Demand Forecast Module

Hi @Candy

You can use the below formula to get the Growth Rate%

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

Thanks

Community Boss

Re: L2 Sprint 2 - 2.3.10 - Create DEM03 Demand Forecast Module

As with the MONTHVALUE function you need to map the value from a module dimensioned by the parent of SKU, Product Family,  to a target dimensioned by the child, P3 SKU list.

Therefore, use LOOKUP as per @Sathya message to pull the Growth Rate % as defined by Product Family and assign it each P3 SKU list item.

The mapping relationship will be define in a line item contained in the P3 SKU list details module.

Good luck,

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
Contributor

Re: L2 Sprint 2 - 2.3.10 - Create DEM03 Demand Forecast Module

Thank you everyone for your assistance 😊.

New Contributor

Re: L2 Sprint 2 - 2.3.10 - Create DEM03 Demand Forecast Module

Can someone help with the Baseline Forecast formula? Greatly appreciate it

New Contributor

Re: L2 Sprint 2 - 2.3.10 - Create DEM03 Demand Forecast Module

Baseline formula:

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)