Forum Discussion
I think that is the same thing as counting the parts of your concatenated field, right? If you use the formula below (in a formula numeric field) you should get '6' as your answer for the example above.
var text value = ToText([# of Note Payments (Concatenations)]);
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,";"))
)
------------------------------
Mike Tamoush
------------------------------
Hey Mike,
It worked! Thank you so much for responding. Much appreciated.
Ashley
------------------------------
Ashley Solomon
------------------------------