4 Replies Latest reply: May 11, 2018 5:52 AM by beck bakytbek RSS

    Show max with help of Aggr()

    beck bakytbek

      Hi Folks,

       

      i got a case, my table does look  the following (please see attached screenshot),

       

      i want to show the sum (Bestand) in depending on max of (W_Zeit)

       

      for example:

      Artikelnr   W_Zeit   Bestand

      1500          280          300

      1500          280          350

      1500          240          120

      1600          140           45

      1600          140           64

      1600          120           100

       

      Output should look like this:

      Artikelnr   W_Zeit   Bestand

      1500          280          650

      1600          140          109

       

       

      i am using this expression: sum(aggr(sum({<W_Zeit = {"$(=MAX(W_Zeit))"}>}Bestand),Artikelnr)) but it does not work

       

      does anybody have any idea, how to resolve this issue

       

      Thanks a lot

      Beck