Extracting entries with round numbers (Idea ver 10.3)

2 posts / 0 new
Last post
Joined: 04/30/2018 - 12:46
Extracting entries with round numbers (Idea ver 10.3)

How do I extract round numbers from database?  I posted this question in another forum by mistake (new here).  Thanks.

Steven Luciani
Joined: 07/31/2012 - 13:20

Hi Denise,

If your are attempting to do some even dollar testing of say a bank statement file, then you would use the modulus feature of IDEA found in the equation editor. If you look on the equation bar, third  button from the right you will see the letters MOD.

To use this feature to look for even dollar amounts divisible by 100 your equation would be:

AMT(numeric field with the dollar amount in it) % (symbol that shows up when you click the MOD button) 100 (divisor amount) = 0 (remainder)

AMT % 100 = 0

To extract these round amount you left click on the Criteria link in the Properties window, which brings up the equation editor, then you write the equation above and execute it. Only round numbers will be displayed. Then you either go to home save as, or the direct extraction feature to extract the even dollar amounts.

If you are looking for something different please expand upon your initial query and I'll do my best to answer your question.