Expression help - using an 'AND' and Not Equal
- 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
Here's an expression I'd like some help with:
IF [Qry Fin Impact] = "Y" AND [Baseline to Final
Reim Change] != 'null'
Then
Round(( [RW Diff] * [Blended Rate 2016]),0.01)
ELSE 00.00
ENDIF
This is giving me the error: Invalid operator !=
In Alteryx what is the NOT EQual operator?
In the IF statement, when you want an AND comparison what is the syntax?
AND I'd really like to find a general overview of expression building in Alteryx but I've not found this in the Knowledge area. Can anyone recommend an overview of how expression are built in Ateryx?
Solved! Go to Solution.
- Labels:
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That's your hint here 🤓
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
YES!
Got it.
IF [Qry Fin Impact] = "Y"
AND !isnull([Baseline to Final
Reim Change])
Then
Round(( [RW Diff] * [Blended Rate 2016]),0.01)
ELSE 00.00
ENDIF
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Note that the ISEMPTY() function is slightly more generous than ISNULL() -- it captures empty records as well as nulls.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Online function docs aren't bad for how to put expressions together: http://help.alteryx.com/9.5/Reference/Functions.htm
Would be nice if we got a step towards Tableau or Excel formula editing in v11. Have found it useful to use them to help with writing formula in past.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
THANKS!!
That is exactly what I've been looking for.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Ah, I like to know there are these little differences. In this situation 'null' is what I need.
Thanks.
