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:

OR

Thank you in advance for any suggestions.

Kathy

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

### 2 Replies

• 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,";"))<>"")

------------------------------