AnsweredAssumed Answered

Suggestion on wrong logic of Calculation

Question asked by user2147901 on Dec 28, 2018
Latest reply on Dec 28, 2018 by fmpdude

Hi, I am new to filmmaker. It is part of my script which is wrong. I am trying to set field on particular field based on the condition.

 

Here is my calculation:

 

1. Case (

 

IsEmpty ( A) ;

 

Case (B = "" and C = "" ;  "" ;

B <> "" and C = "" ; B ;

B = "" and C <> "" ; C ;

B <> "" and C<>"" ; C ) ;

 

not IsEmpty ( A ) ;  A

))

 

I am using filemaker 17. What should I do in order to get correct result?

Outcomes