The register now supports several reporting questions. Choose the row grain before you calculate: a list of open records, a team total and the two largest assignments are different outputs. Keep the record identifier until a grouping deliberately replaces detail with summary.
This set mixes earlier transformations on fresh fictional service data. Some tasks require two steps, so inspect the intermediate result. Remove errors only when the report scope excludes invalid scores; use null when the record must remain. A numeric total should come from a numeric column. The hidden workbook includes a zero-hour record and a different malformed score, which prevents a query from passing by relying on a particular row position.