Excel MOD function in Alteryx to detect multiples of 5

Question

Hello Alteryx fans.  A quick question here.  Is there an equivalent to the MOD function (from Excel) that can be used in Alteryx.  I am trying to detect values in a column that are multiples of $5, up to but not over $40.  My thinking is this cane be done in a Formula Tool.  Is there another (better) way?  Thank you!!

Claje · Accepted Answer

Hi,

Alteryx also has a MOD() function which I believe works the same as excel.

here's an example formula to identify if a value is a multiple of 5 below 40 dollars or not.  Note that this may do something unexpected if you have negative values.

IF MOD([TestValue],5) = 0 AND [TestValue] <= 40 THEN 1 ELSE 0 ENDIF

jdunkerley79 · Accepted Answer

@Claje beat me to it!

This expression should do what you want as well - creating a True / False column