There is a way to do this, although it is not in the units or display settings . . . . .
Blank Value WorkaroundLet's suppose you have a 'Numeric value' field that is displaying zero values
- The first thing to do in your schedule is to create a new Calculated field called 'Blank' (for example) - make it a Number type (if that is what your desired type is)
- Do not put anything in the formula
- Create another Calculated Value field - in this example I've called it 'Hides Zeros', but it can be whatever you want the title to display in your schedule
- This time give it a formula something like:
if(Numeric value > 0, Numeric value, Blank)
- This will hide all zero and negative values
- If you want to display negative values and only hide the zero values, change the > in the formula to =:
if(Numeric value = 0, Blank, Numeric value)
- The next step is to hide the intermediate calculation columns:
- Go to the Formatting tab and make the 'Numeric value' and Blank' columns hidden
Multiple Elements Per RowWhat happens when you have a schedule that displays multiple elements per row, when you have unticked the grouping setting 'Itemise every instance'?
The zeros may return!
In which case refer to this post on Zero values in multiple elements per row Schedules