Discussions

 View Only

  • 1.  Report formula: only show values greater than zero from a column

    Posted 01-26-2023 11:34
    Hi,

    I have a report that includes blank cells and zero values. How do I remove all the blanks and zeros from the report using formula? The hour and pieces column both should have values (no Zeros and blanks on both or either columns)

    Example:

    Hours # of Pieces
    0.1 3
    52 191
    0.1 3
    42 179
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    67 0



    ​

    ------------------------------
    Bibhav Rimal
    ------------------------------


  • 2.  RE: Report formula: only show values greater than zero from a column

    Posted 01-26-2023 11:50
    Have you tried adding filters to your report?

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

    Original Message


  • 3.  RE: Report formula: only show values greater than zero from a column

    Posted 01-26-2023 11:54
    ahh, that worked. Thanks Mark!

    ------------------------------
    Bibhav Rimal
    ------------------------------

    Original Message