7 Replies Latest reply: Apr 12, 2018 8:49 AM by Stefan Wühl RSS

    aggr (i think) function question

    Глеб Аитов

      Hi,

       

      I have the following data.

      I want to SUM (AMOUNT) only those IDs, which are CONFIRMED and have CREATED status in the given period.

       

      Trying the formula formula (it dosn't solve the problem):

      SUM( {<status={'confirmed'}>}  AGGR ( SUM ( {<status={'created'}>} ) AMOUNT), ID ) )

       

      The result should return 100 which is Confirmed amount for Order 500, because it has also Created status in the same period.

       

       

      IDSTATUSAMOUNT
      500created100
      500confirmed100
      700confirmed200

       

      Thank you!