Replace missing values with 0 in cross tab

[xefere]

How do I replace the "." with 0 in a crosstab?

[Astounding]

You can control the appearance of missing values for numerics:

options missing='0';

That will get you "0" instead of "." although the values might not line up the way you hope.

[xefere]

And where to I set this options in VA?

[mccl4488]

You can create a calculated item from the numeric and replace the missing values with 0.. something like

IF ('Customer Engagement'n missing) RETURN 0 

                                                              ELSE 'Customer Engagement'n

and name it as Customer_Engagement2 or something - then use that variable in the crosstab.