State the inclusion rule before the sum
The original synthetic export has A-1 confirmed HK$100; A-2 cancelled HK$80; A-3 confirmed HK$120; and an exact repeated row for A-1. The agreed calculation counts unique confirmed IDs only, using their supplied HKD amounts.
| Requested result | Expected answer | Calculation rule |
|---|---|---|
| Unique confirmed bookings | 2 | A-1 and A-3; exclude A-2 and repeated A-1 |
| Confirmed amount | HK$220 | HK$100 + HK$120 |
| Raw export rows | 4 rows | Count every supplied row because this question asks raw rows |
Do not infer a correction from a conflicting duplicate
A new export contains A-1 at HK$100 and A-1 at HK$130, with no correction marker. What is the expected total?
Show the worked answer
The accepted A-1 amount is unresolved, so the exact total cannot be established. Flag the conflicting values for review rather than choosing the last row or summing both.
Save the included IDs beside the total so a reviewer can verify the membership as well as the arithmetic. This worksheet specifies an editorial calculation rule for synthetic records; a different real business definition requires a different answer key.