why is my formula returning -1

[wonka1234]

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?

[gautiergodard]

Hey @wonka1234 

Try something like this:

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

[Felipe_Ribeir0 · Accepted solution]

Hi @wonka1234 

Try 

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

[AbhilashR]

The syntax would go something like this:

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

[wonka1234]

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

[davidskaife]

Hi @wonka1234 

Try switching it round and see if that works:

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

[AbhilashR]

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