Default Summary Value to £0 if Null

[SamDemon]

Within our company we are trying to run a report on tickets issued per client.

The report is laid out with the following headers:-

Count
Account No
Company Name
Joined
Revenue (Summary)
Tickets Issued (Count)
ATP (Calculation - Revenue / Tickets Issued)

The problem that we are having is that if there has been no tickets sold the 'Revenue' column display nothing. What we would like is for this to default to £0 if Null.

How can we get the value to default to the above if null, any suggestions would be gratefully recieved!!

Sam

It's just common sense, shame sense isn't common!

 

[dgillz]

Use a formula to test for null values:

Is isnull({YourField}) then 0 else {YourField}

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

http://www.gainfocus.biz