Visokio website     Downloads     Video tutorials     KnowledgeBase  
Cumulative function - Visokio Forums
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.
  • 5 Comments
  •     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.
  • checkyourfuel     checkyourfuel 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?
    James Sandoval
    Invizua Limited - Dedicated to Media, Marketing Services and Market Research Organisations

    W: www.invizua.com
    E: james.sandoval@invizua.com
    T: +44 7740 284 164
    A: Innovation Warehouse, 1 East Poultry Avenue, London EC1A 9PT
  •     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+.
Add a Comment

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories

Tagged