null values in Pivot tables

[Anonymous]

To avoid null values in Pivot tables, in the presentation tab I indicated 0 for Null symbol and missing symbol.

When the table is exported to excel, the cells with 0 are considered text format.

Is there a way to make them export as numeric format?

[ashfaq_haseeb]

Hi,

Instead of that solution I would suggest you to handle null in script.

Attached document will help you in doing that.

Let me know if that worked.

Regards

ASHFAQ