Do Not Evaluate if all referenced fields are empty

[Kiith]

My company recently upgraded from FM4 to 6 at at the same time crossed over to PCs. The transition was relatively painless but I'm still having one problem. It seems that FM4 defined the message in the subject line to mean that no calculation will take place until all field contain a value, while FM6 defines it as the value isn't calculated until one of the referenced fields contains a value.

We have 3 fields for this calculation (number) and as soon as one field is referenced the calculation runs and gives a result of zero. If anyone who has come across this can offer any assistance or a suggestion it would be great.

Thanks

[BobWeaver]

FMI acknowledged that it was a bug in the older versions of Filemaker that they corrected in version 5.5. The old versions apparently evaluated the calculation regardless of the status of the checkbox.

[Vaughan]

You could change the calculation to give the result TextToNum("") if all fields are empty.

[BobWeaver]

Wait a second. Is this for an auto-enter calculation, or for a regular calculated field?

Calculated fields will recalculate whenever you change one of the referenced values, so you shouldn't have a problem there. But, you may need to switch the "Do not evaluate if..." option to get the same operation as before.

If this is for an autoenter calculation then I don't know exactly how version 4 behaved because I never used very many of these prior to version 5. However I find that autoenter calcs that are based on several fields usually have to be set up in this form:

Case(

[Kiith]

Thanks Guys, Your right it is a auto-enter calculating field, sorry for not including that in my original post. I thought that the IsEmpty was the answer but my understanding of Filemaker it fairly poor, thank you all for your assistance I'm sure what you've suggested will work.