6 Replies Latest reply on Sep 23, 2019 10:22 AM by Kaz Shakir

    Calculate days worked with a condition

    Cynthia Alofaituli

      I'm trying to calculate the average of encounters a provider has in a month based on the number of days he worked.  I'm counting the day when an encounter is found, except that I don't want to include the days when he has 1 or 2 encounters only (obviously an error) as it will skew his average.  I've been doing a calculated field to "count distinct the date of encounter with the condition that the number of records is >1" as the number of days worked.  But I'm not getting my desired result.  It's still giving the number including those days with 1 encounter.  Example below, June should have 19 days worked only, but still getting 20.  What am I missing?

       

      Cynthia