It's beginning to look a lot like...Advent of Code! Get in the holiday spirit by learning how you can participate in this friendly competition and earn a seasonal badge.
alteryx Community

# Alteryx Designer Desktop Discussions

SOLVED

## Expression help - using an 'AND' and Not Equal

10 - Fireball

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?

6 REPLIES 6
20 - Arcturus
!isnull([fieldname])

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
10 - Fireball

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

12 - Quasar

Note that the ISEMPTY() function is slightly more generous than ISNULL() -- it captures empty records as well as nulls.

ACE Emeritus

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.

10 - Fireball

THANKS!!

That is exactly what I've been looking for.

10 - Fireball

Ah, I like to know there are these little differences.  In this situation 'null' is what I need.

Thanks.

Labels