Sub total amount calculation

[Vapour02]

Hello all professionals,I need help to calculate the credit amount but also to consider the debit amount and date. For example. If debit amount is on 2023-10-07 and the next one is on 2023-10-17 I need to calculate the total credit amount between these two debit amounts date range and then again calculate the total amount between 2023-10-17 and 2023-10-19 and then again the total amount between 2023-10-19 and 2023-10-27.

Also when the total amount is calculated I need to find the difference between the debit amount and the total of all credit amount between the date ranges. Attached is the sample for reference.

[Vapour02]

@OllieClarke Thank you so much for all the help and support. Much appreciated.

[OllieClarke]

No worries @Vapour02. If you've got your answer, would you mind marking the relevant response(s) as a solution, so others can more easily find them later?

Ollie