Trying to ""Count"" the number of selections in a multi-select text field
Hi, I have a multi-select text field : [ERP Products] I'm trying to have a Formula - Numeric field, to count the number of products that were selected. I have tried something like this: ...
Maybe you need to post a screen shot of your source data field. and you are confusing me this this quesiton If(Trim(Part($value,1,";")) <> "", Trim(Part($value,1,";")),"")
what does that how to do with your original question.
This expression here Trim(Part($value,1,";")) <> "" will be true and Count as 1 in a count fucntion of the 1st part of the $value is not blank.
this here
<>
means not equal.
"" means comparing to empty quotes so blank.
------------------------------ Mark Shnier (YQC) mark.shnier@gmail.com ------------------------------
Sorry Mark. Didn't mean to confuse things. You can disregard my "If" statement. Here is a screenshot of the values. The top one is a reference table report that shows the actual values of the multi-select field. You can see that there are 2 values: "Quickbooks Enterprise" and an "Empty" value. In the bottom screenshot is the Summary Report, showing the "Distinct Count" including the empty value in that multi-select field. What I'm looking for is for that number to be "1" instead of "2" (basically excluding the "empty" value)
Does this clarify things?
------------------------------ George Khairallah CTO gotomyerp, LLC ------------------------------
