4 Replies Latest reply: Aug 10, 2017 2:22 PM by Vishwarath Nagaraju RSS

    Running Total in Table

    Ben Petosa

      Hello Everyone,

       

      I am having issues creating a field that is a running total of another. I am using "group by" in the load statement to get engagement by date. I either get a very large number, or the same number as the engagement field. Here is simple example:

       

      Date          Engagement          Total Engagement

      1/1/17               4                                   4

      1/2/17               5                                   9

      1/3/17               16                                 25

      etc......

       

      After I get the running total, I need to find the date where the total hits the engagement goal, which will be the 4th field (not shown).

      I appreciate any help I can get with this.

       

      Thanks,

      Ben