- Data analyst
- Junior
- 30 min
A signed depot revenue report
Plover Dispatch needs result with one row per depot and net as the sum of amount. Keep credits and the depot with a missing label. Ignore missing amounts, then return only depot and net without grouping.
Skills and rubricA signed depot revenue report
- I group shipments by depot and sum signed amounts with missing amounts omitted because a credit reduces net revenue. The missing depot label stays as its own group. I drop grouping and reconcile net with the source sum before handing over the report.
- The missing amount and the negative credit test different rules. I omit the unknown amount from this requested sum, but retain the recorded credit because removing it would overstate revenue. I also retain the unlabeled depot so its money remains visible.
- I retain the source records, the saved work and the checked output because another analyst must be able to reproduce this result. I record the observation window and the unresolved limitation. The decision owner approves any exception before this result changes a business action.