How to calculate the financial value of invoices received and cleared within 1 day of receiving them

[Daniel_K]

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

[Gysbert_Wassenaar · Accepted solution]

Cleared within 24hrs: sum( {<[Invoice number]={"=[Date cleared for payment]-[Date received]<1"}>} [Invoice value])

[Daniel_K]

Brilliant, thank you!