Forum Discussion

BibhavRimal's avatar
BibhavRimal
Qrew Trainee
2 years ago

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

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
------------------------------
  • Have you tried adding filters to your report?

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • BibhavRimal's avatar
      BibhavRimal
      Qrew Trainee
      ahh, that worked. Thanks Mark!

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