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