If statement error on filter

Question

I'm not really sure why I keep getting this error, everything seems like it should work. I keep getting a Malformed if statement error with this filter. The data type going into this filter is int 32 size 4. Please let me know what I need to fix here for this to work.

Screenshot 2023-09-19 095103.png

geraldo · Answer

@maygross

the GL_ACCOUNT_NUMBER field is actually an int32 but you are assigning a string to it. hence the error.
If it needs to be a string, create a new field in the formula e.g.: trim('4898924')

ChrisTX · Answer

Change ELSE IF to ELSEIF

Guessing the output data type in the Formula tool should correctly convert your GL ACCOUNT text value to INT