Formulae: Running total cumulative function

arvindkc · June 19, 2009 6:17PM

Is there a function to determine the cumulative value of a field based on another field. For instance, in a simple table containing two columns, month & profit/(loss), I would like a cumulative value of profit/(loss) by month.

steve · June 22, 2009 6:40AM

Cumulative functions (such as running total) are not available at present but are planned for a future version. You may be able to use the SUBSET_SUM function to calculate the sum for all data, or for some subset of the data.

February 15, 2010 8:35PM

Will a cumulative function for running totals be available in 2.6? If not 2.6, how about 2.7?

tjbate · February 17, 2010 12:02PM

James - we have a plan to put this and other row-based functions in, but we are not sure how long it will be until these functions are available in a beta release.

steve · October 19, 2010 11:27AM

Please see this posting for a way of hacking up a running total using SUBSET functions:
http://forums.visokio.com/comments.php?DiscussionID=453

steve · January 25, 2011 12:17PM

RUNNINGTOTAL function is now available in 2.6 b502+.

Welcome!

Categories

Ideas Parade

Tagged