Trying the following:
Module A:
Lists: Territory, Brands, Versions
Line Items: Avg
Module B:
Lists: Territory, Brand , Versions, Time, Scenarios
Line Items: VolumeA, VolumeB
I have Module A.Avg formula set as ModuleB.VolumeA[Select:Time'FY17', Select:Scenarios.S1]*..
Would like to replace time element in a dynamic way by looking up global module for my model. This time value will change based on global setting.
Appreciate any help.
Thanks,