In Gridview is it possible to have a calculated column with a running total?

Doug

Hi Doug,

There are no built-in features in GridView to create a running total for a calculated column.

It is possible to do this manually, by using the RANGEREF function to determine a set of cells for a particular column, from the the top to the current row, and then SUM them all together. The column numbering for this starts at zero, so here is an example of a calculated column that gives a running total for the numeric 4th column in a view:

SUM(RANGEREF( 3, 1, 3, ROW()))

Note that this only a simple running total from the beginning, not running totals by data value. It would be much more complicated, if at all possible, to do that. I don't think this will work if you are summarizing the view. It also may not work if you are doing special sorting of the records. So perhaps take this suggestion with a grain of salt.

Perfect, does exactly what I needed!

Thank You
Doug