1 Reply Latest reply: Feb 7, 2018 4:10 AM by Stefan Wühl RSS

    Set analysis associated field

    Jurien Groot

      Hi,

       

      I have a master calendar:

      Load 

      ...

        (Year(TempDate)-1) * 12 + Num(Month(TempDate)) as MonthID,

        MonthName(TempDate) as Period

       

      The user can select one Period in the app. I have two metrics:

      Sum( {$<[MonthID]={$(=Max([MonthID]))} >} Money)

      Sum( {$<[MonthID]={$(=Max([MonthID])-1)} >} Money)

       

      If the user selects one Period, the 2nd metric shows 0. How can I let the user select one period and still show (essentially Period-1) via the monthID -1 ?

      If I select one MonthID it works fine. Why can the set analysis not understand the associated field?

       

      I don't want to have a data island btw.