Anterra has built a new SM widget called 'Profit Per Labor Hour'. This widget allows users to see the profit they can make per labor hour in a specific month.
We recognize there is a mismatch between the number on the widget and that on the grid. The mismatch is caused by some of the work orders being excluding from the persisted grid due to their accounting date keys being out of the filtered date range. Specifically, the work orders that have been closed at the end of May but their accounting dates are after May, 31st. Therefore, those work orders cannot be counted on the persisted grid.
The below image is a query to demonstrate what the issue is.