When designing your report, you may encounter some areas where you have a zero value. The zero value may be caused by no activity thus far, a calculation that isn't relevant for all rows or columns of a report, or because of another type of calculation. In some cases it is beneficial to see that zero, while in other cases, it is best to just hide the value to have users focus on more important areas of the report.
The first area to look at is the settings on the Report Definition. Both of these options are on by default.
The next area to look at is to use column restrictions to hide values from printing in certain columns. You can learn more about this feature here. This is often used for when you have total columns and you don't want percentages in a row to be added into a total column. In this example, I have specified that the Gross Profit % row should be printed in columns B-E, but not column F.
The final area to consider is to use a three part format mask. With this, you can define how to handle zeros either at an individual column or row level.