AnsweredAssumed Answered

Proper syntax for a comples expression

Question asked by WilliamBartels on Feb 13, 2011
Latest reply on Feb 14, 2011 by WilliamBartels

Summary

Proper syntax for a comples expression

Product

FileMaker Pro

Version

11v02

Operating system version

Windows 7

Description of the issue

I am trying to write a fairly complex calculation, but I can not get the syntax correct.  I have reviewed the Help until I could probably quote it in my sleep.
Here is the query

If  (BILL > "1800" & DIANE > "1800"
      READ = "X"
ELSE IF (BILL > "1800"
      READ = "B"
ELSE IF (DIANE > "1800
      READ = "D"
ELSE
      READ = " "
END IF

I HAVE TRIED NUMEROUS VERSIONS OF THIS EXPRESSION, BUT I CAN'T GET FileMaker Pro to accept it.

Expected result

IF THE 4 CHARACTER TEXT FIELD "BILL" IS GREATER THAN "1800"
AND THE 4 CHARACTER TEXT FIELD "DIANE" IS GREATER THAN "1800"
THEN THE 1 CHARACTER TEXT FIELD "READ" IS SET TO "X"
ELSE IF "BILL" IS GREATER THAN "1800" THEN "READ" IS SET TO "B"
ELSE IF "DIANE IS GREATER THAN "1800" THEN "READ" IS SET TO "D"
ELSE "READ" IS SET TO SPACE

TRUTH TABLE

               BILL > "1800"  BILL < "1800

DIANE > 1800           "X"      "D"

DIANE < 1800           "B"      " "

Actual result

Errors from FileMaker Pro

Please help me.  I can not purchase FilemakerPro until I am confident I can get the results I want.

Exact text of any error message(s) that appear

function does not exist

not enough parameters for function

function "ELSE IF" not found

depending on where the program sees an error.

Outcomes