Yes, something like this should work in a calculated field…
You can use the "SUM " function from SQL with the “OVER” clause.
Here is an example from PartTran, but it works the same in yours… just change the “partition by” and “OrderBy” fields to your needs.
SUM(PartTran.TranQty) OVER (PARTITION BY PartTran.PartNum ORDER BY PartTran.TranNum)
For more info, read: Data with Bert