Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

!= vs. =!

FrederikE
13 - Pulsar

Hey together, 

 

I just ran into an interesting mistake I just made and am a bit confused about it. 

 

Typed "=!" instead of "!="

 

Mod(10,3)!=0 -> TRUE

Mod(10,3)=!0 -> FALSE

 

What is happening when I type "=!"? 

 

Thought this would make "equals NOT-zero" instead of "NOT-equals zero", which is logically the same thing, but thats, not the case. 

3 REPLIES 3
ShankerV
17 - Castor

Hi @FrederikE 

 

!= Does not equal

=! Boolean NOT !

Here it accepts one input and if that input is TRUE then it will return False.

If the input is False then it return True.

 

Shanker V

 

 

 

 

 

IraWatt
17 - Castor
17 - Castor

@FrederikE 

Just a guess here, first step is to simplify this to what the formula returns:

1!=0

1=!0

 

The first compares the number 1 and the number 0 returning the correct answer. The second I think compares the number 1 with 'Not Zero' which is actually interpreted as the Boolean True. So, the second statement really says the number 1 equals True which causes it to say false. 

The formula tool syntax and interpretation has a lot of quirks so this guess could be completely off.

FrederikE
13 - Pulsar

Hey @ShankerV , @IraWatt ,

Thanks for your responses. An interesting feature -  seems like a very niche use case where this would be used for just requiring two signs. 

Labels
Top Solution Authors