Pro exercise

Allocations must add up to 100%

Each invoice is split across departments by percentage. Every line can be valid on its own while the invoice is not: 60% + 50% is 110%. Validate the lines, then report the invoices whose allocations don't total exactly 100.

validation
aggregation
group rules