11 Replies Latest reply: Apr 11, 2018 5:18 PM by Mathias Vieweg RSS

    calculation of a value in a column depending on the sum of older entries

    Mathias Vieweg

      Hi together,

       

      I would like to have an Diagramm where I can see the packing date and packing time on the x Axis and the "total weight so far" on the y axis.

       

      I do not have re results of the column "total weight so far" and have to calucalte them. The value the "total weight so far" is always the sum of the order weight where the "packing time" is less than the current packing time of the packing date.

       

          

      Orderpacking datepacking timeorder weighttotal weight so far
      A01.03.201807:0050
      B01.03.201807:5095
      C01.03.201808:101217
      D01.03.201812:30623
      E01.03.201814:00831
      F01.03.201815:00940
      G02.03.201806:00100
      H02.03.201807:501110
      I02.03.201808:306721
      J02.03.201811:00988
      K02.03.201814:00897

       

      Thanks for help.

      Mathias