Hi there,
I am running a query which has a Running Total field as below;
RunningTotal: (SELECT SUM(Total_On_Hand)
FROM Daily_Inventory_Report
WHERE T1.Shelf_Life_Date >= Shelf_Life_Date
AND T1.SKU_ID = SKU_ID)
I want to add a condition so that this running total stops and resets when the...
