try if isnull ({PORel.JobSeq}) then 0 else {PORel.JobSeq} of course using the field you want instead of porel.....
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of skc143psu
Sent: Wednesday, October 15, 2008 8:43 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Replace null with zero in Crystal
Good day,
I'm trying to do some calculations in Crystal, but one field has null
values some of the time. I don't wat to touch the database, but thought
there was a way to replace nulls with a 0 integer in crystal, by
writing a fomula in the selection expert. If the value of this field is
not null, it has a significant number that is needed for a calculation,
so this cannot be a boolean expression (I know the syntax to do that).
Has anyone run into this before, and if so, can you send me the formula
for this? Thanks in advance.
________________________________
The information contained in this message is intended solely for the individual to whom it is specifically and originally addressed. This message and its contents may contain confidential or privileged information. If you are not the intended recipient, you are hereby notified that any disclosure or distribution, or taking any action in reliance on the contents of this information, is strictly prohibited.
We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses.
This message (including any attachments) is intended only for
the use of the individual or entity to which it is addressed and
may contain information that is non-public, proprietary,
privileged, confidential, and exempt from disclosure under
applicable law or may constitute as attorney work product.
If you are not the intended recipient, you are hereby notified
that any use, dissemination, distribution, or copying of this
communication is strictly prohibited. If you have received this
communication in error, notify us immediately by telephone and
(i) destroy this message if a facsimile or (ii) delete this message
immediately if this is an electronic communication.
Thank you.
[Non-text portions of this message have been removed]
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of skc143psu
Sent: Wednesday, October 15, 2008 8:43 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Replace null with zero in Crystal
Good day,
I'm trying to do some calculations in Crystal, but one field has null
values some of the time. I don't wat to touch the database, but thought
there was a way to replace nulls with a 0 integer in crystal, by
writing a fomula in the selection expert. If the value of this field is
not null, it has a significant number that is needed for a calculation,
so this cannot be a boolean expression (I know the syntax to do that).
Has anyone run into this before, and if so, can you send me the formula
for this? Thanks in advance.
________________________________
The information contained in this message is intended solely for the individual to whom it is specifically and originally addressed. This message and its contents may contain confidential or privileged information. If you are not the intended recipient, you are hereby notified that any disclosure or distribution, or taking any action in reliance on the contents of this information, is strictly prohibited.
We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses.
This message (including any attachments) is intended only for
the use of the individual or entity to which it is addressed and
may contain information that is non-public, proprietary,
privileged, confidential, and exempt from disclosure under
applicable law or may constitute as attorney work product.
If you are not the intended recipient, you are hereby notified
that any use, dissemination, distribution, or copying of this
communication is strictly prohibited. If you have received this
communication in error, notify us immediately by telephone and
(i) destroy this message if a facsimile or (ii) delete this message
immediately if this is an electronic communication.
Thank you.
[Non-text portions of this message have been removed]