Hello,

I am new to filemaker and I have a question (sorry if it's silly) about calculation.

I want Filemaker to use 3 fields to calculate a score. If any of the fields is missing then I want to get the message "unable to calculate"

This is my formula

3.78 * Log( Bil 2 ) + 11.2 * Log ( INR 2 ) + 9.57 * Log (Cr 2 ) + 6.43

I suppose I need to combine somehow the IsEmpty function but I am not sure how to do it

Can someone tell how to write the whole script including my formula with the IsEmpty function incorporated?If any of the fields is missing then I want to get the message "unable to calculate"

Thank you so much

Marinos

If (

Count ( Bil 2; INR 1; CR 2) <3 ; "unable to calculate";

3.78 * Log( Bil 2 ) + 11.2 * Log ( INR 2 ) + 9.57 * Log (Cr 2 ) + 6.43

)

Realize that the two possible output data of this calculation are text and number.

If you are putting the result of this calc into a field you should consider that showing text in a number field can be confusing to the user.