non calculate 2 fields

[Ben Ball]

I have a calculation field which calculates

fieldA - fieldB = X

but the result calculates even if field A is empty or if fieldB is empty... how can I stop this? I can do it if fieldA is empty but how if fieldB happens to be empty also?...

TIA

Ben

[dreamingmind]

Ben,

At the bottom of the calculation dialog box is a check box for "do not evaluate if all fields are empty"... or there is in FMv9. Can't recall if this is in v6.

However, if it's not there or it doesn't work, you can use a case statement to stop the calc.

case( (test field A) AND (test field ; result-if-both-true ; result-if-not-both-true)

Regards,

Don

[Ben Ball]

I am actually on 8 advanced... however.... yes that box is checked as default but the calculation was still working if one or the other field was empty... maybe because I was using an "if" statements?

however.... thanks for your calc... that works and very handy for me..