Find number ending with "000"

[radjovi]

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.

[benakesh]

Hi @radjovi ,

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

[atulggrwl2]

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

[Corp-Yongcan-Frank-Lu]

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

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

[atulggrwl2]

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

[danilang · Accepted solution]

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]

@danilang 

Thanks a lot, it works perfectly fine.

[ekarita]

The formula works but upon going through the results, I found it is also returning 'true' in example a number such as 0.21 or 0.17