Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to not sum the null amount

Status
Not open for further replies.
Sep 16, 2005
191
US
Hi.. I have a Total Payment Formula that contain the following formula:
{#hazPMTAmt}+{#UstPmtAmt}+{#CalRisPmtAmt}+{#CalAdmPMTAmt}

Problem..
When I display the result it is blank.. I think it's because some of these amount is null. How can I modify my report to display the total amount?
 
Change the formula to:

(
if isnull({#hazPMTAmt}) then 0 else {#hazPMTAmt}
) +
(
if isnull({#UstPmtAmt}) then 0 else {#UstPmtAmt}
) +
(
if isnull({#CalRisPmtAmt}) then 0 else {#CalRisPmtAmt}
) +
(
if isnull({#CalAdmPMTAmt}) then 0 else{#CalAdmPMTAmt}
)

-LB

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top