4 Replies Latest reply: Apr 2, 2015 3:48 AM by Denis Windisch RSS

    Year-1 is ignored in Set Analysis

      Good morning (again) from Germany,


      I have a little problem with Set Analysis and the previous year.


      (Count({$<MasterYear = {"=$(=(MasterYear-1))"},

      DateType = {'Contract_End_Real'}>}DISTINCT(Contract_Key)))


      The expression should count the Contract_Keys for the selected Year-1.

      It is working very well with smaller (<), greater(>), <= or >=. Only with equal it doesn't work. The -1 is actually ignored in that case with equal


      Any idea why?