Mallformed If Statement using a Multi-Row Formula

gregddowns

I keep getting a Malformed If Statement error for the below function. Any help would be much appreciated. Thank you.

IF ISNULL([DEBIT]) THEN IF ISNULL([CREDIT]) THEN "" ELSE

IF CONTAINS([Account],"Total") THEN "" ELSE

IF ISNULL([Row-2:DEBIT]) THEN IF ISNULL([Row-2:Credit]) THEN IF ISNULL([Row-1:Debit]) THEN IF ISNULL([Row-1:Credit]) THEN [Row-2:Account] ELSE

IF ISNULL([Row-1:Debit]) THEN IF ISNULL([Row-1:Credit]) THEN

IF ISNULL([Row-2:Iteration #1]) THEN IF ISNULL([Row-1:Iteration #1]) THEN [Row-3:Iteration #1] ELSE

IF ISNULL([Row-1:Iteration #1]) THEN [Row-1:Account] ELSE

[Row-1:Iteration #1] ENDIF ENDIF ENDIF ELSE ELSE ELSE ELSE ELSE ELSE ELSE ELSE ELSE [Row-1:Iteration #1] ENDIF ENDIF ENDIF ENDIF ENDIF ENDIF ENDIF ENDIF ENDIF

RolandSchubert

Hi @gregddowns ,

translated to Alteryx, your Excel formula would be:

IF ISEMPTY([Debit]) AND ISEMPTY([Credit]) THEN
''
ELSE
IF CONTAINS([Account],'Total') THEN
''
ELSE
IF ISEMPTY([Row-2:Credit]) AND ISEMPTY([Row-2:Debit]) AND ISEMPTY([Row-1:Debit]) AND ISEMPTY([Row-1:Credit]) THEN
[Row-2:Account]
ELSE
IF ISEMPTY([Row-1:Debit]) AND ISEMPTY([Row-1:Credit]) THEN
IF ISEMPTY([Row-1:Result]) AND ISEMPTY([Row-2:Result]) THEN
[Row-3:Result]
ELSEIF ISEMPTY([Row-1:Result]) THEN
[Row-1:Account]
ELSE
[Row-1:Result]

ENDIF

ELSE
[Row-1:Result]

ENDIF

ENDIF

ENDIF

ENDIF

I've attached a sample workflow.

Hope this is helpful.

Best,

Roland

MultiRowIfStatement.yxmd