community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
SOLVED

Find number ending with "000"

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.

Quasar

Hi @radjovi ,

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

Meteoroid

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

Atom

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

 

IF REGEX_MATCH(ToString([Number]),'.+000') THEN
"YES"
ELSE
"NO"
ENDIF

 

 

Meteoroid

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

Nebula
Nebula

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

Atom

@danilang 

Thanks a lot, it works perfectly fine.

Labels