Dynamic Time selection
Trying the following:
Lists: Territory, Brands, Versions
Line Items: Avg
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.
I think you should create small module as per screen below. This module should have no timscale and one line item. Change data type for line item to Time Period and select desired scale. Now you can reference this line item in Avg formula and also put either module or only line item to dashboard to serve as selector.1
Thanks Ł.Szymański !
Tried your suggestion. Formula doesn't error out anymore but I dont see any data. Attached has more details.
Appreciate your help.0
Thanks s.jansenidw! That worked.