Multi-row IF AND statement

[mtqromain]

Good morning,

I am trying to create a formula over multiple rows, and I keep receiving 2 message errors saying "Invalid type in operator ==."

My alteryx attempt is the following formula:

IF
([Collaboration?] == "TRUE" AND [Row+1:Collaboration?] == "FALSE") OR

([Collaboration?] == "TRUE" AND [Consecutive similar PN?] == "False" AND [Row+1:Collaboration?] == "TRUE")
then "Yes"
else ""
endif

Any idea where the problem might come from?

For reference, the excel formula worked as follows:

=IF(OR(
AND([@[Collaboration ?]]=TRUE;O3=FALSE);
AND([@[Collaboration ?]]=TRUE;O3=TRUE;[@[Consecutive similar PN?]]=FALSE);
"Yes";"")

Thanks a lot for your help!

[ShankerV]

Hi @mtqromain 

You need to use only 1 = instead of 2 in the below formula.

Try the below.

IF
([Collaboration?] = "TRUE" AND [Row+1:Collaboration?] = "FALSE") OR

([Collaboration?] = "TRUE" AND [Consecutive similar PN?] = "False" AND [Row+1:Collaboration?] = "TRUE")
then "Yes"
else ""
endif

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @mtqromain 

Please find the expected output.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[mtqromain]

thanks a lot! it works great :)

[ShankerV]

@mtqromain 

The below formula didn't work because Alteryx read the column ([Collaboration?] as Boolean 1 and 0.

IF
([Collaboration?] = "TRUE" AND [Row+1:Collaboration?] = "FALSE") OR

([Collaboration?] = "TRUE" AND [Consecutive similar PN?] = "False" AND [Row+1:Collaboration?] = "TRUE")
then "Yes"
else ""
endif

Hence I tweaked the formula to treat Boolean 

IF ([Collaboration?] = 1 AND [Row+1:Collaboration?] = 0) OR
([Collaboration?] = 1 AND [Consecutive similar PN?] = 0 AND [Row+1:Collaboration?] = 1)
then "Yes"
else ""
endif

Got the result.

Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V