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.
Change ELSE IF to ELSEIF
Guessing the output data type in the Formula tool should correctly convert your GL ACCOUNT text value to INT
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')