How it works
This analytic function will identify all the transactions that are rounded to a specified degree and pull them into a new sheet.
How to use it:
Step 1
In the ‘More’ drop down of the Analysing and Sampling group, click on ‘Find Rounded’.
A new pop-up window will appear.
Step 2
Select the column/header that the values are contained in.
Step 3
Select the rounding level applicable.
Then click OK.
Step 4
The rounded transactions that are identified by the function will be populated into a new sheet.
