I’m trying to execute a sample test that should work as follows, but I don’t really know how to start (without making it very complex).
- My dataset consists of invoice numbers and their respective value.
- The sample test requirement (set by authorities) is that for each € 100.000 the corresponding invoice number should be picked. For example, if the first € 100.000 consists of 2 invoice, both invoice 1 (starting at zero value) and invoice 2 should be picked. If if would be 4 invoices, the only the first and the fourth invoice should be picked (as those invoice touch the zero value and € 100.000. Invoice 2 and 3 are ignored as those are within the € 100.000. In case of an invoice with a value of € 100.000 it should always be picked.
What would be a ‘simple’ way to get the invoices numbers that should be checked?