1 Reply Latest reply: Mar 13, 2012 6:25 AM by Stefan Wühl RSS

    Can I do this with SET analys?

    Göran Hofstedt

      Hi

      I have YearMonth, StartDate and EndDate. What I want is to count a field with ID that have StartDate up to the month selected and Enddate = Today().

      The second picture in the middel desribe what I want and the first what I now get when I select the YearMonth field. (But the EndDate are manually marked at both picts, will just use Today() as expression in the set) 

      I tried this =Count({$<StartDate={">0"},EndDate={'$(=Today())'}>}INSATSID)  but I need it to cut after the month selected so it dont count StartDate in ex 2012 in this example.

      QV Set.JPG