AnsweredAssumed Answered

Calculation Question

Question asked by marinos on Aug 24, 2017
Latest reply on Aug 27, 2017 by marinos

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

Outcomes