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
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
@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 @SathyaM 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,
Thank you everyone for your assistance 😊.
I have inserted a formula successfully but i am not getting any values for other line items. Can anyone please help in this regard.
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]
Very much insightful, Thank you so very much!
You got the right Growth Percentage. please check the Baseline Forecast.
Check out the latest Anaplan feature updates and enhancements in our November 2025 official release notes. The information below offers supplemental information to that post. Intelligence Anaplan Forecaster: General enhancements Anaplan Forecaster now supports list subsets for the item ID list and custom time, list format…
Check out the latest Anaplan feature updates and enhancements in our October 2025 official release notes. The information below offers supplemental information to that post. Planning experience Combined Grids This new capability gives page builders the ability to combine multiple modules into a single, unified grid on a UX…
