CrossTab - displaying "0" in cell but expecting a null value

[smmedeiros]

I'm running Crystal V11.
I've created a cross tab that consist of 3 variables.
My column is workflow seq#. I have 15. These are coded specifically as a formula and used in my record selection criteria. (database has about 50 different workflow sequence #'s and I only want these 15 to report on)
My rows are change ticket #'s.
My summarized field is a formula for difference between workflow start date and workflow enddate.

My problem.
I can have a ticket that has only 12 of the 15 workflow seq# .. when i display the data, the 3 cells for workflow seq#7, workflow seq#14 and workflow seq#15 are displaying as "0" instead of simply being a null field. (The blank cells are not always at the end.. can be anywhere in the workflow sequence)

I can't just simply surpress zero's since the difference between the start and end could be a valid zero. My desire is to have these cells be a null value.

Anyone have any tips/ideas on how to code for this?

Thanks

 

[lbass]

You could consider changing your datediff formula to something like this:

if isnull({table.startdate}) or
isnull({table.enddate}) then
0 else
{table.enddate}-{table.startdate}-.0001

...where you make sure the difference is something other than exact zero. Then format the cells to suppress if zero.

-LB