I have a crystal report that has the following information:

Group

Actual Expenditures (from one table)

Budgeted Expenditures (from another table).

Available Amount (Budgeted - Actual)

End Group - Total for the above three.

 

The problem I have is that there may be actual expenditures for something that there is no budget for and there may be no expenditures for a budgetted item. 

 

In order to get the information I needed, I had to set up a Left-Outerjoin between the Budget Table and the actual transactions.

 

The problem is in the case there are no actual transactions, I don't get anything back (as expected) and I would like to change or set it to 0.  It is also effecting the Avaliable amount (nothing - budget is giving me nothing.

 

I have just started back on Crystal after many years away and I know that I am missing something simple

 

Thanks in advance for all your help.

 

SCG