Null values as zero

[jewseppie]

How do I let my null values appear as zero?

[Gysbert_Wassenaar]

In pivot tables and straight charts you can set the Null Symbol to a 0 on the Presentation tab of the properties window. You can also replace nulls with 0's in the script by adding these two lines at the top of the script:

NullAsValue *;

set NullValue=0;