Skip to main content
Question

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

  • January 26, 2023
  • 0 replies
  • 60 views

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Have you tried adding filters to your report?

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