ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

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

Expressions | Filter Tool | Odd and Even Filtering

JBO
8 - Asteroid

I am building an expression in the Filter tool to isolate data that has an odd number in a particular field. I can't find a function for identifying odd and even values. Is there one?

Thanks.

adm510
11 - Bolide
Mod([Field1], 2)

Use the modulus function, if it returns 0 the number is even, if it returns 1 the number is odd

 

2 % 2 = 0

3 % 2 = 1

4 % 2 = 0

...

 

JBO
8 - Asteroid

Thank you!

 

Labels