L2 Sprint 2 - 2.3.10 - Create DEM03 Demand Forecast Module

Candy
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. 

 

Candy_0-1617512589413.pngCandy_1-1617512616673.png

 

Thank you!

Candy

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Sathya
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

View solution in original post

ChrisHeathcote
Community Boss

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

@Candy 

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

View solution in original post

5 REPLIES 5
Sathya
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

View solution in original post

anjsudheer
New Contributor

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

i am getting error if i use this formula could please help for formula

ChrisHeathcote
Community Boss

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

@Candy 

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

View solution in original post

Candy
Contributor

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

Thank you everyone for your assistance 😊.

 

muizzsk9890
Occasional Contributor

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

muizzsk9890_2-1634018044673.png

I have inserted a formula successfully but i am not getting any values for other line items. Can anyone please help in this regard.