Dynamic Time selection

Options
gujsa01
gujsa01 Member, ALL USERS, Partner Posts: 3 Occasional Contributor
in Planning & Modeling

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,

Tagged:

Comments

  • gujsa01
    gujsa01 Member, ALL USERS, Partner Posts: 3 Occasional Contributor

    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.

     

     

  • gujsa01
    gujsa01 Member, ALL USERS, Partner Posts: 3 Occasional Contributor

    Thanks s.jansenidw! That worked. 

     

    Appreciate it,

Categories