Default Value where no result returned

[acrouch]

I would like a default value to appear in a field where no actual value is returned in the report.

eg.
Field X Field Y Calc Field = X-Y
results eg.
10 5 5
12
11 11 0

There May actually be no result for Field Y and I would like "0" to appear so my calculation works, at the moment if there is nothing returned for Field Y, my Calc Field also returns nothing.

Thanks in adavnce for your help !

Regards,
Antoinette Crouch

 

[AndrewBaines]

If isnull then 0 else y Andrew Baines
Chase International

 

[dgillz]

No formula needed.

Under file, options, reporting tab, check the "Convert NULL field value to default" checkbox. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com