Checking and troubleshooting calculations

Now that we have our calculations seemingly correct, it is important to take a closer look so that we can discover any anomalies or instances that might throw off the calculations.

Boundary cases

A common method of performing checks is to look at boundary cases, or the maximums and minimums of our calculations. To do this, follow these steps:

1. Start by clicking on the % Utilization column header in our table visualization. This sorts the table in descending fashion, where our highest % Utilization number is at the top of the list. We can see what some anomalies of very high utilization might be, such as % Utilization at the top, which is 175.00% for Cole, Camille.
2. To check this number, click on the Data view in the Views bar.
3. Click on the Hours table in the Fields pane.
4. Find the EmployeeID field in the Hours table and click on the drop-down arrow in the column header.
5. Uncheck the (Select all) checkbox to unselect...