Malformed Function Call Error

[sakinazarif]

I'm trying to input IF formula in my alteryx workflow, however I keep getting a malformed function call error, can someone help

If (Length(Trim([ENTRY])) = 0 And Length(Trim([BATCH])) = 0) Or (([ENTRY] = "JRX" And [BATCH] = "2N")) Or (([ENTRY] = "JRX" And [BATCH] = "C1")) Or (([ENTRY] = "PAL" And [BATCH] = "C5")) Then "Stock"
ElseIf Trim([ENTRY]) = "ADI" And Uppercase(Trim([BATCH])) = "AC"
Or Trim([ENTRY]) = "PAL" And Uppercase(Trim([BATCH])) = "2N"
Or Trim([ENTRY]) = "CR" And !IsEmpty(Uppercase(Trim([BATCH])))
Or Trim([ENTRY]) = "DIV" And !IsEmpty(Uppercase(Trim([BATCH])))
Or Trim([ENTRY]) = "JNL" And !IsEmpty(Uppercase(Trim([BATCH])))
Or Trim([ENTRY]) = "NRT" And !IsEmpty(Uppercase(Trim([BATCH])))
Or Trim([ENTRY]) = "PRN" And !IsEmpty(Uppercase(Trim([BATCH])))
Or Trim([ENTRY]) = "REI" And !IsEmpty(Uppercase(Trim([BATCH])))
Or Trim([ENTRY]) = "RTC" And !IsEmpty(Uppercase(Trim([BATCH])))
Or Length(Trim([ENTRY]) = 0 And Length(Trim([BATCH]) != 0 AND !Contains([BATCH], "OD") Then "Dividend"
ElseIf Trim([ENTRY]) = "INT" Then "Distribution"
Else If Trim([ENTRY]) = "PAL" And Trim([BATCH]) = "A3" or ([ENTRY] = "PAL" And [BATCH] = "MC")
Then "Sec Fees" Else ""
Endif
Endif
Endif
Endif

[lwolfie]

Length(Trim([ENTRY]) is missing a closing )

[sakinazarif]

closed it, but I still have the error - what am I missing?

If Length(Trim([ENTRY]) = 0) And Length(Trim([BATCH])) = 0 Or ([ENTRY] = "JRX" And [BATCH] = "2N") Or ([ENTRY] = "JRX" And [BATCH] = "C1") Or ([ENTRY] = "PAL" And [BATCH] = "C5") Then "Stock"
ElseIf Trim([ENTRY]) = "ADI" And Uppercase(Trim([BATCH])) = "AC"
Or Trim([ENTRY]) = "PAL" And Uppercase(Trim([BATCH])) = "2N"
Or Trim([ENTRY]) = "CR" And !IsEmpty(Uppercase(Trim([BATCH])))
Or Trim([ENTRY]) = "DIV" And !IsEmpty(Uppercase(Trim([BATCH])))
Or Trim([ENTRY]) = "JNL" And !IsEmpty(Uppercase(Trim([BATCH])))
Or Trim([ENTRY]) = "NRT" And !IsEmpty(Uppercase(Trim([BATCH])))
Or Trim([ENTRY]) = "PRN" And !IsEmpty(Uppercase(Trim([BATCH])))
Or Trim([ENTRY]) = "REI" And !IsEmpty(Uppercase(Trim([BATCH])))
Or Trim([ENTRY]) = "RTC" And !IsEmpty(Uppercase(Trim([BATCH])))
Or (Length(Trim([ENTRY]) = 0) And Length(Trim([BATCH]) != 0 AND !Contains([BATCH], "OD") Then "Dividend"
ElseIf Trim([ENTRY]) = "INT" Then "Distribution"
ElseIf Trim([ENTRY]) = "PAL" And Trim([BATCH]) = "A3" or ([ENTRY] = "PAL" And [BATCH] = "MC")
Then "Sec Fees" Else ""
Endif
Endif
Endif
Endif

[lwolfie · Accepted solution]

You still need to close the next Length  "Length(Trim([BATCH]) != 0"

[sakinazarif]

ahh voila! this works! thank you so much