8 Replies Latest reply on Feb 27, 2016 7:11 PM by sccardais

    Calculation to count fields meeting defined criteria.

    sccardais

      I am trying to create a calculation that shows how many fields in the same record meet certain criteria.

       

      I want the calculation to show how many of these fields meet certain criteria and the criteria are different for each field. In some cases, I'm looking for a value of "Yes" in the field. In others, I'm looking for a specific value.

       

      The calculation is currently based on the values in 10 other fields in the same record but this could change.


      1 "point" is assigned to each "hit". If five of the 10 fields meet the criteria, the calc field would show 5.

       

      What's the best way to do this?

       

      ---

       

      P.S. The data table shows which features in our product are being used (Yes / No) and how much certain features are being used (number values).

       

      We want to identify customers who aren't using certain features at all or enough to get the full benefit. The calculation field is basically a Non-Utilization Score. Higher scores are Worse.