topic Re: L2 Sprint 2 - 2.3.10 - Create DEM03 Demand Forecast Module in Academy & Training https://community.anaplan.com/t5/Academy-Training/L2-Sprint-2-2-3-10-Create-DEM03-Demand-Forecast-Module/m-p/125688#M3528

You got the right Growth Percentage. please check the Baseline Forecast.

 

SudhirY_0-1638107381431.png

 

 Sun, 28 Nov 2021 13:50:21 GMT SudhirY 2021-11-28T13:50:21Z L2 Sprint 2 - 2.3.10 - Create DEM03 Demand Forecast Module https://community.anaplan.com/t5/Academy-Training/L2-Sprint-2-2-3-10-Create-DEM03-Demand-Forecast-Module/m-p/104139#M3043

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

 

 Sun, 04 Apr 2021 05:09:26 GMT https://community.anaplan.com/t5/Academy-Training/L2-Sprint-2-2-3-10-Create-DEM03-Demand-Forecast-Module/m-p/104139#M3043 Candy 2021-04-04T05:09:26Z Re: L2 Sprint 2 - 2.3.10创建DEM03需求ecast Module https://community.anaplan.com/t5/Academy-Training/L2-Sprint-2-2-3-10-Create-DEM03-Demand-Forecast-Module/m-p/104155#M3044

Hi  

 

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

 Mon, 05 Apr 2021 06:26:43 GMT https://community.anaplan.com/t5/Academy-Training/L2-Sprint-2-2-3-10-Create-DEM03-Demand-Forecast-Module/m-p/104155#M3044 SathyaM 2021-04-05T06:26:43Z Re: L2 Sprint 2 - 2.3.10创建DEM03需求ecast Module https://community.anaplan.com/t5/Academy-Training/L2-Sprint-2-2-3-10-Create-DEM03-Demand-Forecast-Module/m-p/104307#M3047

 

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  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, 

 Tue, 06 Apr 2021 12:31:43 GMT https://community.anaplan.com/t5/Academy-Training/L2-Sprint-2-2-3-10-Create-DEM03-Demand-Forecast-Module/m-p/104307#M3047 ChrisAHeathcote 2021-04-06T12:31:43Z Re: L2 Sprint 2 - 2.3.10创建DEM03需求ecast Module https://community.anaplan.com/t5/Academy-Training/L2-Sprint-2-2-3-10-Create-DEM03-Demand-Forecast-Module/m-p/104817#M3063

Thank you everyone for your assistance .

 

 Sun, 11 Apr 2021 01:58:13 GMT https://community.anaplan.com/t5/Academy-Training/L2-Sprint-2-2-3-10-Create-DEM03-Demand-Forecast-Module/m-p/104817#M3063 Candy 2021-04-11T01:58:13Z Re: L2 Sprint 2 - 2.3.10创建DEM03需求ecast Module https://community.anaplan.com/t5/Academy-Training/L2-Sprint-2-2-3-10-Create-DEM03-Demand-Forecast-Module/m-p/121784#M3424

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.

 Tue, 12 Oct 2021 05:55:29 GMT https://community.anaplan.com/t5/Academy-Training/L2-Sprint-2-2-3-10-Create-DEM03-Demand-Forecast-Module/m-p/121784#M3424 muizzsk9890 2021-10-12T05:55:29Z Re: L2 Sprint 2 - 2.3.10创建DEM03需求ecast Module https://community.anaplan.com/t5/Academy-Training/L2-Sprint-2-2-3-10-Create-DEM03-Demand-Forecast-Module/m-p/122507#M3444

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

 Mon, 18 Oct 2021 11:11:36 GMT https://community.anaplan.com/t5/Academy-Training/L2-Sprint-2-2-3-10-Create-DEM03-Demand-Forecast-Module/m-p/122507#M3444 anjsudheer 2021-10-18T11:11:36Z Re: L2 Sprint 2 - 2.3.10创建DEM03需求ecast Module https://community.anaplan.com/t5/Academy-Training/L2-Sprint-2-2-3-10-Create-DEM03-Demand-Forecast-Module/m-p/123833#M3464

Your module may contain line name as "Growth %", thus replace the same below in the formula-

 

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

 Wed, 03 Nov 2021 06:10:29 GMT https://community.anaplan.com/t5/Academy-Training/L2-Sprint-2-2-3-10-Create-DEM03-Demand-Forecast-Module/m-p/123833#M3464 NehalMasrani 2021-11-03T06:10:29Z Re: L2 Sprint 2 - 2.3.10创建DEM03需求ecast Module https://community.anaplan.com/t5/Academy-Training/L2-Sprint-2-2-3-10-Create-DEM03-Demand-Forecast-Module/m-p/125659#M3527

Very much insightful, Thank you so very much!

 Sat, 27 Nov 2021 02:15:26 GMT https://community.anaplan.com/t5/Academy-Training/L2-Sprint-2-2-3-10-Create-DEM03-Demand-Forecast-Module/m-p/125659#M3527 Shahenaz 2021-11-27T02:15:26Z Re: L2 Sprint 2 - 2.3.10创建DEM03需求ecast Module https://community.anaplan.com/t5/Academy-Training/L2-Sprint-2-2-3-10-Create-DEM03-Demand-Forecast-Module/m-p/125688#M3528

You got the right Growth Percentage. please check the Baseline Forecast.

 

SudhirY_0-1638107381431.png

 

 Sun, 28 Nov 2021 13:50:21 GMT https://community.anaplan.com/t5/Academy-Training/L2-Sprint-2-2-3-10-Create-DEM03-Demand-Forecast-Module/m-p/125688#M3528 SudhirY 2021-11-28T13:50:21Z