How to check for even numbers?

[H369199]

Hi,

I want to read only even numbers in a column?

Please let me know the formula.

Regards,
Praveen

[Akshay1]

Hello Praveen,

Please use the following compute statement to check whether the values in your column are even/odd. if(find(".",STR(@ColumnName@/2)) >0,"odd","even")

Once you perform this compute, you could use the remove rows function to get rid of the odd values.

I hope this helps.

Thank You and Best Regards,
Akshay