Level 2 Sprint 2 DEM03 Growth Rate % line Item

Joh04924
Occasional Contributor

Level 2 Sprint 2 DEM03 Growth Rate % line Item

 

For this line item, it is needed to align the dimensionality of the Source Module to Target Module, so that the Target Module can reference the Growth Rate % of the Source Module. See below for mapping reference:

Screen Shot 2020-06-30 at 4.41.32 PM.png

The issue I am having is that I am unable to properly map the formula. Resulting in various error messages.

I have been using variation of LOOKUP, and LOOKUP & SELECT functions, to no avail.

13 REPLIES 13
Tricia
Contributor

@Joh04924  - were you able to resolve this? I am having the same issue.

 

Thanks!

neg177
Super Contributor

Hi,

 

Were you ever able to figure out the Formula for the growth rate line item in Moduel DEM03?

SRoberts
Community Manager

Looks like everyone has figured the correct SYS08 Product Family Lookup for this line, but recall that in a prior step we created DEM02 Volume Growth Rates by Week using formula 'MONTHVALUE('DEM01 Volume Growth Rates'.Growth %)' to bring the monthly value in DEM01 down to a weekly level.

 

My formula was successful when I accessed that weekly growth rate data.

jjayavalli
Contributor

Hi, so are you suggesting to divide the MONTHVALUE/ 4 to get the weekly Growth %? I have used the Lookup Function here instead.

so wondering. Thank you:)