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.

[Former Member]

if your cross tab measure object is sales revenue

create formula like this

=If(IsNull([Sales Revenue]);0;[Sales Revenue])

the formula shows if there is null (empty) value take 0(zero) and if the cell has a value then it take own value...

All the best.

[Former Member]

Hi Tom,

You can write this formula,

= If(IsNull([Amount Sold]);0;[Amount Sold])

Regards,

Narendra.

[amrsalem1983]

replace the cell of [Sales] by this

= if(isNull([Sales]);0;[Sales])

good luck

[former_member584698]

Hi 2tkwok,

you can type formula in formula bar for that object like

If([sale]=" ") then "0" else [sale]

just for representation it will show you 0 where value is blank

[Former Member]

thanks that worked!

[Former Member]

Hi Tom,

You can define it in the undefined part of the Number Format (available in the Display section of the properties) for that cell.

If the return type of variable is not Number then you can write the formula and display it.

Regards,

Rohit