Counting values in a single field
I need to count the number of apartment units entered in a field we have called Unit #, There is always a comma to separate them, but I cannot quite seem to figure out how to use the count fu...
Forum Discussion
how can I include, that if the field is blank, return a blank?
Thank you,
Brandy Nunes| Sales and Marketing Coordinator
FSI Construction | Foundation Specialists
Office: (972) 239-4374 | Cell: (281) 755-2684
Houston • Austin • San Antonio • DFW • Arizona • Nevada
MarkShnier__You
Qrew Legend
Qrew Legendnp
var text value = [my comma separated text field];
var number NumUnits = 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,";"))<>"");
IF($NumUnits > 0, $NumUnits)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var text value = [my comma separated text field];
var number NumUnits = 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,";"))<>"");
IF($NumUnits > 0, $NumUnits)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- So I'm not good at this...If I change $NumUnits to be my field Unit #5, then I get this error?I don't understand this, my field type is formula - NumericI really appreciate your help.Thank you,Brandy Nunes| Sales and Marketing CoordinatorFSI Construction | Foundation SpecialistsOffice: (972) 239-4374 | Cell: (281) 755-2684Houston • Austin • San Antonio • DFW • Arizona • Nevada
- MarkShnier__YouPlease post you whole formula by copy paste, not screen shot.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- apologies, I was trying to show the errors I was getting based on the formula you previously provided.var number NumUnits = Count(Trim(Part([Unit #5],1,","))<>"",Trim(Part([Unit #5],2,","))<>"",Trim(Part([Unit #5],3,","))<>"",Trim(Part([Unit #5],4,","))<>"",Trim(Part([Unit #5],5,","))<>"",Trim(Part([Unit #5],6,","))<>"",Trim(Part([Unit #5],7,","))<>"",Trim(Part([Unit #5],8,","))<>"",Trim(Part([Unit #5],9,","))<>"",Trim(Part([Unit #5],10,","))<>"",Trim(Part([Unit #5],11,","))<>"",Trim(Part([Unit #5],12,","))<>"",Trim(Part([Unit #5],13,","))<>"",Trim(Part([Unit #5],14,","))<>"",Trim(Part([Unit #5],15,","))<>"",Trim(Part([Unit #5],16,","))<>"",Trim(Part([Unit #5],17,","))<>"",Trim(Part([Unit #5],18,","))<>"",Trim(Part([Unit #5],19,","))<>"",Trim(Part([Unit #5],20,","))<>"",Trim(Part([Unit #5],21,","))<>"",Trim(Part([Unit #5],22,","))<>"",Trim(Part([Unit #5],23,","))<>"",Trim(Part([Unit #5],24,","))<>"",Trim(Part([Unit #5],25,","))<>"",IF([Unit #5] > 0, $NumUnits));.Thank you,Brandy Nunes| Sales and Marketing CoordinatorFSI Construction | Foundation SpecialistsOffice: (972) 239-4374 | Cell: (281) 755-2684Houston • Austin • San Antonio • DFW • Arizona • Nevada