LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only
  • 1.  Calculate Running Sum

    Employee
    Posted 10-02-2015 07:41

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: mgp

    I am trying to calculate a running sum that will reset by a given field. I've tried to use AggEx and remove the where last in group condition but it did not work.
    Please see the attached example. I'd like to calculate the column highlighted in yellow.
    Thank you for any help!

    Running Sum Example.PNG


  • 2.  RE: Calculate Running Sum

    Employee
    Posted 10-05-2015 10:56

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: lnason

    Paste the contents of the attached brn file into a graph and run. The first parameter tab of the "Rolling Calculations" node allows you to select which fields to sum, group and sort by. The second parameter tab in the composite allows you to select what kind of rolling calculations you want to execute.

    Luke
    Attachments:
    RunningSum.brn