cancel
Showing results for 
Search instead for 
Did you mean: 

How to check for even numbers?

NiCd Battery
Hi,

I want to read only even numbers in a column?

Please let me know the formula.

Regards,
Praveen
Labels (1)
0 Kudos
1 Reply
DC Motor
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
0 Kudos