I have a cross tab that has 4 columns. Some of the counts on these colums are 0 so the cross tab is suppressing those columns.

 

Is there any way to force the colums to appear with 0 in them such as a formula that says

 

if count is null then display 0

else display count

 

I have tried this but it doesnt seem to work, it brings back ridiculously large numbers.

 

Any suggestions?

 

Thanks