Alteryx Designer Discussions

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

Find number ending with "000"

5 - Atom

Hi,

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
"YES"
ELSE
"NO"
ENDIF

 

 

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
   "True"
Else
   "False"
Endif

 

 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.  

 

Dan

5 - Atom

@danilang 

Thanks a lot, it works perfectly fine.

Labels