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.
Go to Solution.
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]
View solution in original post
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.
Thank you everyone for your assistance 😊.
Can someone help with the Baseline Forecast formula? Greatly appreciate it
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)