Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

IIF Statement Error Malformed If Statement

alphabex18
8 - Asteroid

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

3 REPLIES 3
Thableaus
17 - Castor
17 - Castor

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
15 - Aurora

Hey @alphabex18 

 

Try removing the second iif()

 

iif.PNG

 

Neil

alphabex18
8 - Asteroid

 Thank you!

Labels