Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm looking for help to calculate the financial value of invoices received and cleared within 1 day of receiving them to help ensure we're achieving a KPI
Data set example:
Supplier | Invoice number | Invoice value | Date received | Date cleared for payment |
Supp1 | Invoice1 | 100 | 01/05/2019 | 01/05/2019 |
Supp1 | Invoice2 | 100 | 01/05/2019 | 01/05/2019 |
Supp1 | Invoice3 | 200 | 01/05/2019 | 01/05/2019 |
Supp1 | Invoice4 | 200 | 01/05/2019 | 01/05/2019 |
Supp1 | Invoice5 | 200 | 01/05/2019 | 01/05/2019 |
Supp1 | Invoice6 | 300 | 01/05/2019 | 03/05/2019 |
Supp1 | Invoice7 | 300 | 01/05/2019 | 03/05/2019 |
Supp1 | Invoice8 | 100 | 01/05/2019 | 03/05/2019 |
Supp1 | Invoice9 | 100 | 01/05/2019 | 03/05/2019 |
Supp1 | Invoice10 | 100 | 01/05/2019 | 03/05/2019 |
Expected chart output summary based on the above information
Supplier | Date received | Number of invoices | Overall value | Cleared within 24hrs | Cleared within 72hrs |
Supp1 | 01/05/2019 | 10 | 1700 | 800 | 900 |
Cleared within 24hrs: sum( {<[Invoice number]={"=[Date cleared for payment]-[Date received]<1"}>} [Invoice value])
Cleared within 24hrs: sum( {<[Invoice number]={"=[Date cleared for payment]-[Date received]<1"}>} [Invoice value])
Brilliant, thank you!