Hi All,
I have got a problem I can't resolve. I have a report that has four fields, two of them are numeric. There are null values in a couple of these numeric fields. I would like to have the report display "NO DATA" in these fields that are null, however any formulas I try I get a data mismatch error. Is there any way around this? I need to keep the fields numeric because I do calculations on them. And with the null values that are currently there, there are several "Blank" spots in the report. Any help would be greatly appreciated.
Thanks
D
I have got a problem I can't resolve. I have a report that has four fields, two of them are numeric. There are null values in a couple of these numeric fields. I would like to have the report display "NO DATA" in these fields that are null, however any formulas I try I get a data mismatch error. Is there any way around this? I need to keep the fields numeric because I do calculations on them. And with the null values that are currently there, there are several "Blank" spots in the report. Any help would be greatly appreciated.
Thanks
D