Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I let my null values appear as zero?
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;