I have a dataset with unique customer IDs (Customer ID, Contract ID (Similar to loanID which can have several payments), Deposit (Down payment by customer), Transaction ID(Generated anytime customer initiates payment) , Amount (what customer has paid) .

I need help with a calculation for the total amount paid by each customer and also the outstanding left to be paid using PRODUCT PRICE (also a column).