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

    Set Analysis Count values over 20 days



      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.