4 Replies Latest reply on Nov 30, 2016 5:42 AM by lukec48455228

    counting fields which contain specific letter

    lukec48455228

      Hi

       

      I have a form which has a series of different fields called "1st", "2nd", "3rd" etc all the way to "31st". The user is prompted to add either "ab" or "s" or a number to reflect the number of hours worked on the day or whether an employee was sick (s) or absent (ab).

       

      The calculation for adding up the number of hours worked across the month is simple.

       

      How do i add a custom calculation to add up the number of fields which either contain "s" or "ab"?

       

      Cheers