07-11-2017 08:13 AM
I have a list of incoming payments, the payments are related to debts. The payer is not necessarily same person who the debt belongs to (i.e. someone else can pay off the debt). I want to count how many debts the person whose debt was paid off had BEFORE and AFTER the payment in question.
So one row could look something like this:
Payment date // Payment amount // Payer // Debtor // Debts before payment // Debts after payment
I've looked in to solving this with a conditional COUNT function (e.g.: COUNT(payment date < loan date) but this doesn't seem to work.
Help would be much appreciated.