Forum Discussion
Running Total, Not Date Based
Hello, I have a table that I'm trying to get a running total on each row for the previous 6 rows. For example, for the TermAxis 0 row (21EW6), I want to sum the In-term leads for the rows with term...
Columns TermAxis and MinTermAxis! what do they represent? where are they coming from?
TermAxis is a database field to sort our terms chronologically. It continually updates so the ongoing term is always 0. The most recently completed term is -1 and so on.
MinTermAxis was my attempt to create a field I could use in a calculation to try and sum InTermLeads where the TermAxis was between MinTermAxis and TermAxis.
So, for example, for 21EW6 (UG TermAxis 0), I want to sum the InTermLeads for all rows that have a UG term axis of 0, -1, -2, -3, -4, and -5.
Does that help? I know it can be confusing!