Multi-Row formula malformed function call

[alexg1]

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

[Thableaus · Accepted 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,

[alexg1]

Whoops, guess I need to get my eyes checked. Thank you!