SUM each Payment row Running Total (YTD) by Vendor ID/Name?
Summary:
My code succeeds when my query for one Vendor, but needs to be reset for the whole report (muliple Vendors)
A running total ( YTD Amount) for each group of Vendor payments, but needs to be reset when Vendor_ID changes so my ROWS BETWEEN clause is in error when a new Vendor is read
Select VI.Vendor_ID,
VI.Vendor_Name,
VI.Address_Number,
VI.Individual_Tax_ID,
VI.License_Status,
VI.EEO,
VI.classification,
CI.check_date,
CI.Payment_Amount,
SUM(CI.Payment_Amount) OVER(ORDER BY CI.check_date
ROWS BETWEEN UNBOUNDED PRECEDING
AND CURRENT ROW) YTD
Tagged:
0