IIF Statement Error Malformed If Statement

[alphabex18]

Im getting a "Malformed If Statement"

I am using a multi-row tool, and this is my expression. The expression worked perfectly before i added in the red portion, and now i get the error. What am i doing wrong?

iif(isempty([Row-1:EEPID]),1,iif([Row-1:EEPID]=[EEPID] AND iif([Row-1:MemberType]=[MemberType]),[Row-1:PlanOrder]+1,1))

Thanks in advance

[Thableaus · Accepted solution]

Hi @alphabex18 

I think you added an extra iif.

See correct expression:

iif(isempty([Row-1:EEPID]),1,iif([Row-1:EEPID]=[EEPID] AND [Row-1:MemberType]=[MemberType],[Row-1:PlanOrder]+1,1))

Cheers,

[LordNeilLord · Accepted solution]

Hey @alphabex18 

Try removing the second iif()

Neil

[alphabex18]

 Thank you!