As described in my previous blog post, the method used is an application of the modulo operator.

## The Logic

In order to check whether a number is odd or even we have to look at the remainder when the number is divided by 2. More specifically we have to check if the remainder is *not* equal to 0. If it is not equal to 0 then it is odd and when it is equal to zero then it is even.

There are alternatives but we have to be careful of the common pitfalls.

## Tableau

In order to work out if a Number is odd or even, you have to create the following calculated field:

For a given set of Numbers, this is the output shown in the Data Source tab:

## Alteryx

To work out whether a Number is odd or even in Alteryx, we have to create something similar with a Formula tool:

For a given set of Numbers, this is the output:

As we can see, the results is as we expect and is consistent across both Tableau and Alteryx. Good times.