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

Find number ending with "000"

radjovi
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.

6 REPLIES 6
benakesh
12 - Quasar

Hi @radjovi ,

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

atulggrwl2
7 - Meteor

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

FrankLu
5 - Atom

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

 

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

 

 

atulggrwl2
7 - Meteor

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

danilang
19 - Altair
19 - Altair

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

radjovi
5 - Atom

@danilang 

Thanks a lot, it works perfectly fine.

Labels