3 Replies Latest reply on Sep 13, 2017 3:00 AM by sally ball

    Calulated field to count No of records for multiple criteria

    sally ball

      Hi,

       

      I need to create a calculated field as above.  Its to count the total number of records where:

      • The persons age is 16, 17 or 18 (which is already a calculated field at a set date)
      • and their eligibility status meets two of three possible statuses ('Eligible' or 'Not eligible' - ignoring a third status of 'Invalid')

       

      Can anyone suggest a solution please?