Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thank you Vidyut - this will help me putting these values into buckets for further filtering. Appreciate the input.
@vidyut thats an interesting view which didnt come to mind however, it will count zeroes no matter where it is:
100000111
@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. 🙂
@vidyut interested in your mystery function. could that find magnitude of the number (K,M,B,...)? could be a new thread
lets not talk about decimal places rt? : )
Depends on how you have the data stored. You have a valid point though 😊