Discussions

 View Only
  • 1.  Need Formula to Count Amount of Items

    Posted 19 days ago
    Good Afternoon All,

    My company is conducting a baggage survey where we must record all types and weights of baggage during the operation.  My form is set up as items 1-20, as well as weights 1-20.  I had no problem creating a total weight field, but I need a formula field that counts the amount of items.  The item field has words instead of numbers (such as personal bag, checked bag, crew bag, etc.), so I need a formula that will count any of these as 1 and then total it up.

    Appreciate any help you can offer!
    Aidon

    ------------------------------
    Aidon Olligschlager
    ------------------------------


  • 2.  RE: Need Formula to Count Amount of Items

    Posted 19 days ago
    Try this

    Count(
    [Bag Type 1] <> "",
    [Bag Type 2] <> "",
    etc
    [Bag Type 20] <> "")


    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Need Formula to Count Amount of Items

    Posted 19 days ago
    Yes, Mark!  Worked perfect.

    Thanks,

    ------------------------------
    Aidon Olligschlager
    ------------------------------