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!
@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. 🙂