Formula to sum columns doesn't work CR 9 1

[melburstein]

I have a detail line with four columns:

ACBUDHDR.TOTAL-BUDGET
ACCOMMIT.BALANCE-AMOUNT
ACMASTER.BALANCE-AMOUNT

The fourth column contains the formula:

ACBUDHDR.TOTAL-BUDGET - ACCOMMIT.BALANCE-AMOUNT - ACMASTER.BALANCE-AMOUNT.

The only time the fourth column is correct is when the other three columns contain numbers. Otherwise, it is blank.

ACMASTER is my primary table. There is a one-to-one relationship to ACBUDHDR and a one-to-many relationship to ACCOMMIT. From what I have read, I think my problem may be Null values, but I am a relatively new user and can not seem to construct a formula to replace the one that does not work.

I will be grateful if anyone can suggest the exact formula that I need to use. Like I said, I am new. Thank You.

 

[dsz]

Crystal simply stops processing when it encounters a null value. This happens with numbers or string concatenations. You can either enforce a zero default for numbers in your database or let Crystal set the null values to a default by setting the report options to convert them.

File/Report Options - Convert Database NULL Values to Default.

Good luck!