Hello, I am very new to crystal reports and have problem you can help me solve.

I have a data set that contains null values and when the columns are added together no total is summed because of the null value.

You can see below the five columns that are being added together. The last column is the one that sometimes contains a null. When it does contain a null the total for that particular row is not summed up using the formula below. My question is how do I replace the null with zero so a total can be summed. I would rather change the report then change the stored proc in the database that is gathering the data.

You can see I made an attempt to deal with the null in the last column, I found this on this forum. Unfortunately this does not seem to work. Any thoughts on how I can deal with this?

{USP_RptTotalOrders;1.mail_orders}+
{USP_RptTotalOrders;1.webmacs_orders}+
{USP_RptTotalOrders;1.tapemacs_orders}+
{USP_RptTotalOrders;1.phone_orders}+
IIF(IsNull({USP_RptTotalOrders;1.corporate_orders}), 0, {USP_RptTotalOrders;1.corporate_orders})