Even Dollar Amounts

[gfisch13]

Good morning folks - I'm working with a file of purchase orders and want to identify only those that have even amounts, for instance, $10,000, $50,000, $1,250,000, $6,000,000.   I've searched these boards but have yet to hit on what I'm looking for.   Is there an easy way to do this.  In other applications I've seen this called Round Amounts or Flat Dollar Amounts.  Just not sure what to call it here.  

Appreciate the guidance.  Thanks!

George

[gfisch13]

Thank you Vidyut - this will help me putting these values into buckets for further filtering.  Appreciate the input.

[edwin]

@vidyut thats an interesting view which didnt come to mind however, it will count zeroes no matter where it is:
100000111

[vidyut]

@edwin  yes, you are correct. I was just stressing the point that in case you want to extract more features, start looking at the number as string, that may give you some interesting options.

In this case, to count the trailing zeros, if the whole dollar amount  is available in field txtNum, an expression of the form len(txtNum)-[hidden function call on txtNum] would return the number of trailing zeros. 

Can you guess what is this function? I could give the solution, but thought it would be a fun exercise. 🙂

[edwin]

@vidyut interested in your mystery function.  could that find magnitude of the number (K,M,B,...)?  could be a new thread

[vidyut]

@edwin 

ok, I give you the answer, If you use len(txtNum) - findOneOf(txtNum,`123456789`,-1), You should get the exact number of Trailing Zeros , which was the feature we were after.

@gfisch13 , Try incorporating this one, and let me know your interesting finds 🙂

Cheers

[edwin]

lets not talk about decimal places rt?  : )

[vidyut]

Depends on how you have the data stored. You have a valid point though 😊