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
Solved!去解决方案。
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
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@SathyaMmessage 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,
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
i am getting error if i use this formula could please help for formula
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]
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@SathyaMmessage 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,
Thank you everyone for your assistance.
Very much insightful, Thank you so very much!
I have inserted a formula successfully but i am not getting any values for other line items. Can anyone please help in this regard.
You got the right Growth Percentage. please check the Baseline Forecast.