Forum Discussion

BrandyNunes1's avatar
BrandyNunes1
Qrew Member
5 years ago

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 q​uite seem to figure out how to use the count function.

I have a field called # of units that I would like to use the formula in.


Any help is appreciated.

Brandy​



------------------------------
Brandy Nunes
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    try this
    var text value = [my comma separated text field];

    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,";"))<>"")

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        np

        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
        ------------------------------