Do not perform a calculation

[daddioja]

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?

[The Shadow]

Use the IsEmpty() function to check:

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

[daddioja]

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.

[-Queue-]

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.

[daddioja]

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