2 Replies Latest reply on Apr 10, 2016 6:00 AM by Yuri Tupizin

    Running Sum Using LOD

    Yuri Tupizin

      Hi,

      I would like to create a running sum without using the running sum function (I would like to make 2nd aggregation later on)

      Is it possible to achieve this with LOD ? or any other way

      Thanks,

      Yuri

        • 1. Re: Running Sum Using LOD
          Rody Zakovich

          Hello Yuri,

           

          Currently, we are unable to perform moving windowed functions via LoDs.

           

          That said, if you provide more detail, or possibly an example workbook, I'd be happy to assist in finding a solution to your problem.

           

          Regards,

          Rody

          • 2. Re: Running Sum Using LOD
            Yuri Tupizin

            Hi,

            My data look like this:

             

               

            Account IDDateTotal Price
            101/02/2014100
            108/07/2015-50
            109/03/2016-50
            201/02/201410
            208/07/2015-10
            209/03/2016

            70

             

            I would like to calculate running total price for each account like so :

             

             

            Account ID201420152016
            1100500
            210070

             

            Now for each Account & Year I would like to calculate Bool field, let's call it "dead account"

            where "dead account" = 1 if running total over the "Total Price" = 0 and 0 otherwise.

             

            In The final step I would like to aggregate it by year ( I would like to see # of dead accounts for each year)

            like so :

             

             

            201420152016
            011

             

            Any help would be great

            Thanks,

            Yuri