Hello all,
I've been trying to apply some conditional logic to some records to update a preexisting 1/0 true/false field. I've written the following expression:
IF findstring([DEPART/ARRIVE],substring([DEPART/ARRIVE],1,6)=substring([Row-1:DEPART/ARRIVE],1,6)
AND [DATE]=[Row-1:DATE]
AND [Unique Stops] = 1
THEN 0
ELSE [Unique Stops]
ENDIF
I get a malformed function call at the 'THEN' clause, but I can't seem to determine why. Any assistance is appreciated.
Thank you,
Alex
Solved! Go to Solution.
Hi @alexg1
You're missing a parenthesis after the 1st substring function.
IF findstring([DEPART/ARRIVE],substring([DEPART/ARRIVE],1,6))=substring([Row-1:DEPART/ARRIVE],1,6)
AND [DATE]=[Row-1:DATE]
AND [Unique Stops] = 1
THEN 0
ELSE [Unique Stops]
ENDIF
Cheers,
Whoops, guess I need to get my eyes checked. Thank you!