Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Excel MOD function in Alteryx to detect multiples of 5

robertfishel
8 - Asteroid

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!!

3 REPLIES 3
Claje
14 - Magnetar

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
ACE Emeritus
ACE Emeritus

@Claje beat me to it!

 

2018-10-19_15-30-34.png

 

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

robertfishel
8 - Asteroid

Thank you both very much :)

Labels