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?
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.
Retrieving data ...