Tip:
Highlight text to annotate it
X
Number Analysis The Number Analysis tool will simply extract
any records where the amount is rounded to the specified number of zeros, ends in "999"
or has a zero value. The column where the amount is held must first
be selected. To extract rounded numbers tick this box and select the chosen rounding base.
TopCAATs can search for values rounded to 10, 100, 1000, 10,000, 100,000 and 1 million.
To extract transactions ending "999" and zero value transactions, tick the relevant boxes.
TopCAATs will then extract records with rounded, "999" and zero values, each to a separate
worksheet.