Forum Discussion
MarkShnier__You
Qrew Champion
Can you post your whole formula?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
GeorgeKhairalla
3 years agoQrew Trainee
Sure.. it's actually exactly the one suggested in this thread:
var text value = ToText([Product Add-On Apps]);
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,";"))
)
This formula is being used as a report formula field in the Summary Report.
------------------------------
George Khairallah
CTO
gotomyerp, LLC
------------------------------
var text value = ToText([Product Add-On Apps]);
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,";"))
)
This formula is being used as a report formula field in the Summary Report.
------------------------------
George Khairallah
CTO
gotomyerp, LLC
------------------------------
- MarkShnier__You3 years agoQrew Championtry 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
------------------------------- GeorgeKhairalla3 years agoQrew TraineeHm. 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
------------------------------- 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
------------------------------