BibhavRimal
2 years agoQrew Trainee
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:
------------------------------
Bibhav Rimal
------------------------------
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
------------------------------