Forum Discussion

KathyBenjamin's avatar
KathyBenjamin
Qrew Trainee
2 years ago

Counting "Plans" Formula

I have a field called Plans.  (Text Field).  I'm trying to write a formula to count how many plans are being audited by an individual each month.

The Field Plan can have anything from one plan to many plans.

Ex:

Plan: A (Answer 1)

OR

Plan: A,B,C,D,E,F (Answer 6)

Thank you in advance for any suggestions.

Kathy



------------------------------
Kathy Benjamin
------------------------------
  • Try this, but you will need to change all the semi colons to commas.  



    var text value = [Plans];

    Count(
    Trim(Part($value,1,";"))<>"",
    Trim(Part($value,2,";"))<>"",
    Trim(Part($value,3,";"))<>"",
    Trim(Part($value,4,";"))<>"",
    Trim(Part($value,5,";"))<>"",
    Trim(Part($value,6,";"))<>"",
    Trim(Part($value,7,";"))<>"",
    Trim(Part($value,8,";"))<>"",
    Trim(Part($value,9,";"))<>"",
    Trim(Part($value,10,";"))<>"",
    Trim(Part($value,11,";"))<>"",
    Trim(Part($value,12,";"))<>"",
    Trim(Part($value,13,";"))<>"",
    Trim(Part($value,14,";"))<>"",
    Trim(Part($value,15,";"))<>"",
    Trim(Part($value,16,";"))<>"",
    Trim(Part($value,17,";"))<>"",
    Trim(Part($value,18,";"))<>"",
    Trim(Part($value,19,";"))<>"",
    Trim(Part($value,20,";"))<>"",
    Trim(Part($value,21,";"))<>"",
    Trim(Part($value,22,";"))<>"",
    Trim(Part($value,23,";"))<>"",
    Trim(Part($value,24,";"))<>"",
    Trim(Part($value,25,";"))<>"")



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • KathyBenjamin's avatar
      KathyBenjamin
      Qrew Trainee

      Thank you very much.  



      ------------------------------
      Kathy Benjamin
      ------------------------------