How can I make a calculation field empty or bland until the equation is complete. A-B=C
Say A=1 and i have not yet entered B I don't want C to equal -1.
So I want C to display only once both A and B have Data.
C = If ( isempty(A) or Isempty(B); GetAsNumber(""); A-B )
I would make C a calculation with an if statement ie if A is greater than blank and B is greater than blank then perform the calculation A - B, otherwise leave blank
If ( a >"" and b > "" ; a - b ;"" )
David are correct, but instead of If I always use Case because I think it is easier to read each line
// First statement
IsEmpty( FieldA ); Then do this;
// Second statement
IsEmpty/ FieldB ); Then do that;
Show last option
I also recommend you to read free FileMaker Training Series
FileMaker Training Series | FileMaker
Retrieving data ...