![caseware idea stratification 10 largest values caseware idea stratification 10 largest values](https://i.ytimg.com/vi/eJRhxQ6Uj-Q/hqdefault.jpg)
An example would be sorting a file on social security number to see if any blank or "999999999" numbers exist.Ĭombines specified fields from two different files into a single file using key fields. Sorts a file in ascending or descending order. For example, identify any gaps in check sequence. Identifies gaps within a specified field in a file. Examples include extracting all balances over a predefined limit. An example would be to export customer address information to Word for "Mail Merge"ing to customer confirmation letters.Įxtracts specified items from one file and copies them to another file, normally using an "if" or "where" statement.
CASEWARE IDEA STRATIFICATION 10 LARGEST VALUES SOFTWARE
For example, this report could be used to identify duplicate billings if invoices within the sales file.Ĭreates a file in another software format (e.g., Excel, Word) for testing.
![caseware idea stratification 10 largest values caseware idea stratification 10 largest values](https://image.slidesharecdn.com/20140305bl-140710064913-phpapp02/95/the-power-of-benfords-law-in-finding-fraud-10-638.jpg)
Identifies duplicate items within a specified field in a file. By cross-tabulating character fields, you can produce various summaries, explore areas of interest, and accumulate numeric fields.Ĭompletes digital analysis tests (i.e., Benford’s Law). For example, the net payroll pay to an employee could be recalculated using the gross pay field and deducting any withholding/taxes.Ĭross Tabulate lets you analyze character fields by setting them in rows and columns. Maintains a documentation log of all procedures performed on a data file.Ĭreated a calculated field (which can use a function such as ABS for the absolute value of the field) using data within the file. An example would be tomerge two years worth of accounts payable history into one file. Outfit your entire audit team with ActiveData for Excel for less than the costĬombines two files with identical fields into a single file.