formula with null or 0

[DanHD]

Hello

If you have a formula between a few fields where one or some off the fields has the value ‘null’ or 0, you’ll receive an error and the report is not printed.
What is the best practice to handle with this issue. I thought an if-then analyze for first checking every field if the value <> null or 0. But is this the best practice?


Dan

 

[simian336]

Simply the presence of 'null' or 0 should not cause a error.

However in situations where it does you could use a CASE statement.

Could you describe the error in greater detail?

Simi