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.
0 kommentar(er)
