6 Replies Latest reply: Jun 2, 2016 5:18 AM by Inna Shnaiderman RSS

    Aggregated Sum

    Inna Shnaiderman

      Hi,

      I have the following table (attached).

      I need to develop a column (Backlog) which will be aggregated sum of the column (Old_Backlog) and looks like:

       

       

         

      DateIncomingOutgoingBacklogOld_Backlog
      01/05/20167,1737,16100
      02/05/201688,73586,6381212
      03/05/201689,98787,5362,1092097
      04/05/201676,22573,8964,5602451

       

      Backlog of 03/05/2016 is Old_Backlog of 01/05/2016 + Old_Backlog of 02/05/2016+Old_Backlog of 03/05/2016.

      Backlog of 04/05/2016 is Old_Backlog of 01/05/2016 + Old_Backlog of 02/05/2016+Old_Backlog of 03/05/2016 + Old_Backlog of 04/05/2016.

       

      For this purpose i used function Aggr in the following way:

      Backlog=

      =sum(aggr(sum(Old_Backlog),Date))

       

      but it does not work and shows data of Old_Backlog.

      Please help.

       

      Thanks,

      Inna