Addition in Crystal Report 8.5 1

[CrystalProcessor]

I'm struggling with what seems to be a simple problem. I want to

1) add fields A + B + C + D + E + F and display them as @G. I am using this in my formula {A} + {B} + . . . + {F}. It returns zero even when the fields have values. The SQL data type is money.

2) after that, I would like to sum the variable for grouping. I plan to do it this way SUM(@G, GroupName). What would you all recommend?

Thanks!

 

[Charliy]

It could be that one of the fields is null and that's messing up the whole formula.

Go to Report Options ( under File) and check "Convert Database Null Values to Default" (it may be somewhat different, I'm not looking at 8.5)

If that doesn't work try this in your formula:

(if isnull({a} then 0 else {a)) + (if isnull({b}) then 0 else {b}) + . . .

 

[CrystalProcessor]

Thank you! My sanity is saved. (And the report too.)