Fill empty cell with '0'

[Former Member]

Hi,

I have a crosstab table and some of the cells within the table are empty purely because there is no data in the database which is reasonable.

For presenation purposes, what are my options to fill these empty cells with '0'?

I was hoping to find an option to default empty cells to '0', but failed to find such feature.

Thanks in advance.

Regards

Tom

[Former Member · Accepted solution]

Hi Tom

Steps to fill empty cell with '0':-

1. Select intersection cell in cross tab.

2. Go to properties tab.

3. In Text Format section, click on Number Format button.

4. Select Format type is 'Number' and check the Custom check box.

5. Enter 0 in all text boxes(Positive, Negative, Equal to zero, and Undefined).

6. Click ok.

Now you can see 0 in the Emply cells of cross tab.

If you want decimal values, enter 0.00 in Positive box.

[Former Member · Accepted solution]

Thanks guy. All replies are extremely helpful. Issue resolved.