If statement error on filter
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
maygross
8 - Asteroid
‎09-19-2023
06:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
2 REPLIES 2
16 - Nebula
‎09-19-2023
07:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Change ELSE IF to ELSEIF
Guessing the output data type in the Formula tool should correctly convert your GL ACCOUNT text value to INT
geraldo
13 - Pulsar
‎09-19-2023
07:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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')
