why is my formula returning -1

Column = If [Date1] > [Date2] then "FAIL"
Or [Date1] = "N/A"
else Null() ENDIF

the logic should be

If date1 is greater then date 2, mark Column as Fail , otherwise Null

OR if Date1 has a "N/A" in it, mark column as Null.

Whats wrong here?

Custom Tools

Accepted answers

Try

If [Date1] > [Date2] and [Date1] != "N/A" then "FAIL"
else Null() ENDIF

Try something like this:

If [Date1] > [Date2] then "FAIL"
elseif contains([Date1],"N/A") then null()
else Null() ENDIF

Try

If [Date1] > [Date2] and [Date1] != "N/A" then "FAIL"
else Null() ENDIF

The syntax would go something like this:

IF [Date1]>[Date2]
	THEN 'Fail'
ELSEIF [Date1] = 'N/A'
	THEN Null()
ELSE Null()
ENDIF

very odd, none of these solutions are working. When Date1 = N/A I am still getting fail in my column.

Try switching it round and see if that works:

IF [Date1] = 'N/A'
THEN NULL()
ELSEIF [Date1]>[Date2]
THEN 'Fail'
ELSE NULL()
ENDIF

@wonka1234 - are you able to share a few sample datapoints from your set to help us better troubleshoot?