# Help with Running Total Logic in Part Transaction History Tracker (BAQ)

**URL:** <https://www.epiusers.help/t/help-with-running-total-logic-in-part-transaction-history-tracker-baq/125185>\
**Category:** Kinetic ERP\
**Tags:** baq, kinetic, ssrs\
**Created:** [April 25, 2025, 10:16am UTC](https://www.epiusers.help/t/help-with-running-total-logic-in-part-transaction-history-tracker-baq/125185 "2025-04-25T10:16:51Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Mark\_Wonsil](https://www.epiusers.help/user_avatar/www.epiusers.help/mark_wonsil/32/51594_2.png) [@Mark\_Wonsil](https://www.epiusers.help/u/Mark_Wonsil)\
**Post date:** [April 25, 2025, 10:35am UTC](https://www.epiusers.help/t/help-with-running-total-logic-in-part-transaction-history-tracker-baq/125185/2 "2025-04-25T10:35:22Z")

</div>

In the PartTran record, there is a BeginQty and an AfterQty. I imagine you could find the last AfterQty on the previous day and use that as a starting point and then add/remove the delta between those fields.

As for doing the running total, you can use Window Functions in SQL as done here:

> [@Running Total BAQ](https://www.epiusers.help/t/running-total-baq/56131):
>
> I am trying to do a BAQ with a running total. The column I need as a running total is called “Month To Date Shipped”. I exported the BAQ so if anyone could help me I would appreciate it. [GS\_RPT\_Daily\_Invoices.baq](https://epiusers.help/uploads/default/original/3X/9/4/944a5cb3813c9d7e9a5c7e864244ab9949e45e38.baq) (33.0 KB)

---

_[View the full topic](https://www.epiusers.help/t/help-with-running-total-logic-in-part-transaction-history-tracker-baq/125185)._