Forum Discussion
MarkShnier__You
Qrew Champion
try this
var text value = ToText([Product Add-On Apps]);
Count(
Trim(Part($value,1,";"))<>"",
Trim(Part($value,2,";"))<>"",
Trim(Part($value,3,";"))<>"",
etc etc
Trim(Part($value,20,";"))<>"")
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
var text value = ToText([Product Add-On Apps]);
Count(
Trim(Part($value,1,";"))<>"",
Trim(Part($value,2,";"))<>"",
Trim(Part($value,3,";"))<>"",
etc etc
Trim(Part($value,20,";"))<>"")
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
GeorgeKhairalla
3 years agoQrew Trainee
Hm. I don't think that made a difference. Still seems to be picking up the empty values.
As a side note, I'm not sure understand the meaning of Trim(expression) <> "" ... is this a shorthand for my "If" statement?
If(Trim(Part($value,1,";")) <> "", Trim(Part($value,1,";")),"")
------------------------------
George Khairallah
CTO
gotomyerp, LLC
------------------------------
As a side note, I'm not sure understand the meaning of Trim(expression) <> "" ... is this a shorthand for my "If" statement?
If(Trim(Part($value,1,";")) <> "", Trim(Part($value,1,";")),"")
------------------------------
George Khairallah
CTO
gotomyerp, LLC
------------------------------
- MarkShnier__You3 years agoQrew ChampionMaybe 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
------------------------------- GeorgeKhairalla3 years agoQrew TraineeSorry 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
------------------------------- MarkShnier__You3 years agoQrew Champion.. I think that someone would have to look at your app, one on one. You can contact the Quickbase Care Team or else email me directly.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------