Thank you Sarah,
Works great.
Mark
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Tuesday, February 25, 2003 12:20 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal reports null field?
This should work.
I opened crystal and did the same as you and entered the following
equation:
if isnull({LaborDtl.LaborHrs})
then 0
else {LaborDtl.LaborHrs}
and, I get the correct results (a 0.00 if it's null and the value if it's
not.
[Non-text portions of this message have been removed]
Works great.
Mark
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Tuesday, February 25, 2003 12:20 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal reports null field?
This should work.
I opened crystal and did the same as you and entered the following
equation:
if isnull({LaborDtl.LaborHrs})
then 0
else {LaborDtl.LaborHrs}
and, I get the correct results (a 0.00 if it's null and the value if it's
not.
[Non-text portions of this message have been removed]