When selecting data to generate any type of chart, it's important to understand how zero values are handled.

Where line items have the type Number, Anaplan enters a zero into any field that is empty or contains a null value. Consequently, there is no way to differentiate between a system-generated zero and a data value of zero.

When formatting Number fields, in Blueprint, you have option to display zeros as Zero, Blank, or Hyphen. This is simply a display option. If you choose to display a Blank cell or a Hyphen, the cell will still contain a zero value.

All chart types will display zero values where:

  • They are in between the first and the last values in a data set.
  • The initial zero values in a data set.

When generating a Line chart, where a series of zeros occurs at the end of a data set, the trailing zeros will not be displayed.

For example, when a line chart is generated from this selection:

Example line chart source with zero values.

The chart displays the zeros at the beginning of the data set but does not display the zeros and the end of the data set:

Line chart with zero values.

If the design of the module supports it, you can use a very small value, applied via a conditional statement, to have the chart to display a near-zero value. For example:

IF value = 0 THEN 0.000001 ELSE value