Missing Number formating

[agni_gold]

Hi Friends,

I have one pivot table in which I have done suppress zero value, now in the place of Missing Values I have written 0.0, but when I exporting table to excel, then it's 0.0 will come in text format, and other will be in number format,

How can I get all number in number format?

[sunny_talwar]

Missing values are unfortunately formatted as text... the alternative that we have used in the past is to use a macro to export the chart where we can fix the formatting

[agni_gold]

Any other alternative ?

[sunny_talwar]

Convert Missing Values into nulls or 0 in the script

[agni_gold]

they are already 0 from the script , but when I am clicking on suppressing Zero values then they become "-"

[sunny_talwar]

Then don't suppress zero values

[agni_gold]

business want because a lot of dimension values are present which has 0 data, and the user doesn't want to see.

[sunny_talwar]

I am confused, do they want to remove rows which are all 0s, but see other places? May be a sample might help to see how the setup is

[agni_gold]

yes absolutely correct, when a full row is zero then suppress 0 should happen.

[sunny_talwar]

okay