IDEA Users Working Remotely: We’re here to help! Please contact our IDEA Help Desk to ensure there is minimal disruption to your daily workflow.

X
Icon


Tech Tip: Removing the Grand Total


Every once and a while, you may have a data file to import that contains a grand total that you do not want to include in your IDEA database. It takes a few minutes to manually remove the grand total and proceed with the import, but if you forgot and the import has already taken 25 minutes….then what?

 

Is there a way to remove the grand total without having to re-import the file? Yes!

 

Identify which record contains the grand total (usually the last record in the IDEA database). Use the Range feature in Direct Extraction to remove the grand total by setting the range to include all of the rows except the row with the grand total.

 

EXAMPLE:

 

The last line of the database contains a grand total. To remove it:

  • Select Direct on the Analysis tab in the Extract group.
  • Click the Range option button. The starting and ending record numbers will populate automatically.
  • Change the Ending Record to be one less than the total number of records.
  • Set the File Name as desired. Notice there is nothing in Criteria.
  • Click OK.

The new file created by the direct extraction will be one record less than the original file and the grand total will be gone.

If you have questions about this, or other IDEA functions, please contact IDEA Help Desk at 888.641.2800 x4 or email: [email protected]


CaseWare IDEA , Tech Tip



Posted By

By Danny Betancourt


Related Posts
Tech Tip: Truth in Numbers
Jul 20 Fraudsters can be sneaky. While there are some legitimate reasons for employees to be listed in the customer master files, there are also potential fraud scenar...
Exploring IDEA's Built-In Power of Python
Aug 20 In December of 1989, Dutch programmer Guido van Rossum was looking for a hobby programming project to keep him occupied during a slow work week around Christmas...
Expensive Expenses: Identifying Fraud in T&E
Nov 13 Expense Reports and Travel and Entertainment expenses are both common areas for fraud and challenging to find. These frauds are complex and contain a mix of pre...
BROWSER NOT SUPPORTED

This website has been designed for modern browsers. Please update. Update my browser now

×