Multi-conditional IF THEN ELSEIF ELSE ENDIF erroring out while typing.
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
When I am typing in a formula, it all goes in fine until I type the endif, then I get the red squiggly error symbol under the =. It goes bad as I type the last letter f. Everything is meant to be V_String. See screenshots below:
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Please ignore, user error. The Region field was Boolean, should've been V String. Apologies.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
One way to avoid this in the future is to use either the Field Info tool, Select tool, or even the Auto-Field tool to see your data types - then you won't run into this again @ppatane
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@caltang Grazie! Will do.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Any suggestions as to why this formula is not working - tried several different ways. Thank you
If ([Role] = "PCP" or [Role] = "BOTH") and
([Specialty] ="General Practice” Then "Role match"
ElseIF
[Specialty] = “Family Practice” Then "Role match"
ElseIF
[Specialty] = “Geriatric Medicine/Family Prac” Then "Role match"
ElseIF
[Specialty] = “Internal Medicine” Then "Role match"
ElseIF
[Specialty] = “Geriatric Medicine/Internal Me” Then "Role match"
ElseIF
[Specialty] = “Adolescent Medicine” Then "Role match"
ElseIF
[Specialty] = "Pediatrics” Then "Role match"
ElseIF
[Specialty] = “Pediatric Internal Medicine” Then "Role match"
ElseIF
[Specialty] = “Obstetrics & Gynecology – CA P” Then "Role match"
ElseIF
[Specialty] = “General Practice - Dental”)
Else "Role MisMatch"
ENDIF
