Formula Error

[victora]

I'm on CR10, SQL2000.
I'm trying to add 12 fields with data type 'float' (thought to be numeric...) from a table imported from an Access DB. For some reason, there are NULL values which mess up my calculation.

How can I convert NULL to zero without creating a formula for each 12-month bucket.

Thanks

 

[dgillz]

Under file, options, check the 'convertnull field value to default' checkbox.

If this does not work, use formulas as the following:

If Isnull({YourField}) then 0

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.srhconsulting.com