I am using Crystal Reports 2008.

I am having issues getting the Syntax correct for a formula.

The report is grouped by customers.I have 2 commands. The first one will always have a value but the second one has a value for some of the customers but not all.

What I need to do is write a formula that will use just a value of the first command if the second command does not have a value for that customer. If the second command does have a value then it should take the sum of command one and two.

I have tried it like this:

IF ISNULL({Command_2.fin_bal_60})

THEN

{Command_1.inv_bal_60}

ELSE

{Command_1.inv_bal_60} + {Command_2.fin_bal_60}

That is not working because when I put it into the report it only shows the records that have a value in command_2.

I am trying to figure out how to write this so even if command_2 does not return a value it just uses command_1.

Any help on this would be great.

Thanks in advance.