5 Replies Latest reply: Jan 19, 2016 6:23 AM by Jonathan Dienst RSS

    Set Analysis Count values over 20 days

      Hi,

       

      I'm hoping somebody can assist with the following expression:

       

      =count({$<Skill={'1'}, NewOld={'Old'}, Role={'3'}, Active={'Y'}, Date={'=date(today()-20,'dd/mm/yyyy''}>})distinct(ID))

       

      I'm trying to count the number of unique IDs where the latest date is over 20 days, how can I do this? the above formula that I tried doesn't work.

       

      Best

      Mav