Calculations Involving Empty Fields

[NoahR]

Another question because y'all are so ******* smart.

When I have a calculation field, I don't want it to calculate the result if ANY of the referenced fields are blank. I know of the "Do not calculate if all referenced fields are empty" check box, but of course that's not what I want.

Is this possible?

[The Shadow]

You can wrap your calculation with:

If ( not (IsEmpty(field1) or IsEmpty(field2) or IsEmpty(field3) or ... );

<your calculation here>

)

[Lee Smith]

You can wrap your calculation with:

If ( not (IsEmpty(field1) or IsEmpty(field2) or IsEmpty(field3) or ... );

<your calculation here>

)

Two changes one is for US versa Non US and v7 and prior versons, and that is the ";" is a ",", and the calculation needs a comma after <your calculation here> and "" before the last ")"

Here is the calculation modified to work in v6 etc.

If( not (IsEmpty(field1) or IsEmpty(field2) or IsEmpty(field3)),

<your calculation here>

, "")

Lee