I have a calculation field that is field 1 * field 2. Field 1 always has data, but field 2 does not. I want the calculation to not occur if either field is blank. I have the option "Do not evaluate if all referenced fields are empty," but since field 1 is never empty it always returns a 0. I want to use this data in a graph, so I would like it to not calculate any data so it won't mess up my graph. Any advice on how keep the calculation from running?

Use the IsEmpty() function to check:

If ( IsEmpty(field1) or IsEmpty(field2), ""; field1 * field2 )

Thanks Shadow. I am a novice, so bear with me... The "if" statement goes in the calculation for the field, yes? And what does the "" do? Thanks for the clarification.

Yes, that would be the full calculation instead of just field1 * field2. "" returns a null result. It isn't really necessary, though. You can use Case( not (IsEmpty(field1) or IsEmpty(field2)), field1 * field2 ), with no need to specify a 'false' result.

Thank you both. Right on the money! Thanks for the explanation Queue. I appreciate it.