Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Find number ending with "000"

5 - Atom


I am testing a journal entry for an audit procedure and I am trying to highlight or filter out rounded numbers ending with "000".  Can anyone point me to the tools. 


Thanks for your help.

12 - Quasar

Hi @radjovi ,

You can use tostring() to convert to string and  endswith()  to check  if number ends with '000'.

Alteryx Certified Partner

You can use regex tool by using the pattern [000]

5 - Atom

Assume we have column Number. you can use RegEx to check.


IF REGEX_MATCH(ToString([Number]),'.+000') THEN



Alteryx Certified Partner

You can use the following RegEx Command .*?000$

17 - Castor
17 - Castor

Hi @radjovi 


You can also use the following function to populate a boolean field


If Mod([FieldName],1000)=0 then


 The Mod() function looks at the remainder after dividing by 1000.  If it's 0, then the number ends in 000 and the result is true.  Any thing else gives false.  



5 - Atom


Thanks a lot, it works perfectly fine.