Tips and Hints

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

I have used environment variables in the past to drive VBA script - Info: https://msdn.microsoft.com/en-us/library/office/gg264486.aspx
Is there such a function that can be used with IDEA? I am trying to determine if there is method of reading the version of IDEA being used to drive an IF statement in my code. Example, if running IDEA v7, Excel export is restricted to v97-2003 & 64k rows

I have an IDEA Project to do on the @lower function, I'm new to IDEA and get what I have appended but I need to come up with a business use for the function, I deal with sorting Purchase Invoices, linking names with similar address.
Lee

Jeff Sorensen from Caseware has a tech tip on how to verify that you have created your extraction prior to actually doing the extraction.  This way you don't cluter up your history with false attempts.  You can find Jeff's blog at http://www.casewareanalytics.com/blog/idea-tech-tip-%E2%80%93-verify-yo…

Audimation has come out with a Field Statistics Primer that anyone interested (and everyone should be) should check out.

https://www.audimation.com/Resources/Articles/the-field-statistics-prim…

Audimation has just released an article on the Common @Functions in IDEA.  You can find it here:  https://www.audimation.com/Resources/Articles/common-functions-in-idea-…

Hello everyone!
When preparing an IDEA script, is there any command I can use that will tell IDEA to automatically override any existing database in the project and/or existing files the script might create?
I have scripted more with ACL and in ACL, that command is SET SAFETY OFF.  When this command is used in a script, any existing ACL table or file that is created by the script will be automatically overridden.
I was checking to see if IDEA had a similar command.
Thanks in advance for the help!
Mike

Not directly IDEA related but as a common source for IDEA imports is Excel spreadsheets it is good to make sure that the data you are bringing into IDEA is correct.  This article walks you through some of the tools that can be used for auditing a spreadsheet, some of them I didn't know existed.

http://www.journalofaccountancy.com/issues/2015/nov/how-to-debug-excel-…

Audimation, has posted a pdf with some of the magic of field statistics.  They also show how you can incorporate field stats into your equations.  You can find the pdf here.

Just saw this on the audimation web site.  Some interesting information that you might want to check out. http://www.audimation.com/pdfs/top-10-idea-uses.pdf