BAQ Running Sum

[Banderson (Brandon Anderson)]

I think the BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING part might not be needed, or maybe overly specific. I think by default it uses only the previous row.

There’s some more good info in this post about how that code works.

Perform a calculation on BAQ Summary Fields

I think you might be able to do this with a window function query. You can see an example with the system BAQ named: zGSTR1-B2B_InvcDtl_IN . If you change the ICE.QueryHdr.CGCode to an empty string you can load the BAQ in the designer and see how Epicor created it. What you want is to sum it over the group something like: SELECT CustNum, OrderNum, PartNum, SUM(UnitPrice*OrderQty) OVER(PARTITION BY PartNum) AS SubTotal FROM ERP.OrderDtl; There is a ton of information on window functions here:…