I am trying to get the growth rate but adding 'DEM02 Volume Growth Rates by Week'.growth%(lookup:'SYS08 SKU Details'.Product Family) formula but the message is coming as invalid. I tried to lookup the SY08 product family as an intermediary module since dimensions are not same but still the message is showing invalid. attaching the screenshot for the same.
So, so close. Your syntax is correct but you're using "()" on the LOOKUP Function. You can try using "" instead. so 'DEM02 Volume Growth Rates by Week'.growth%[LOOKUP:'SYS08 SKU Details'.Product Family]