3 Replies Latest reply: Oct 15, 2014 8:16 AM by Joey Stekkinger RSS

    combining SUM, IF and DISTINCT in a textobject

    Joey Stekkinger

      Dear community.
      As a designer I would like to count the amount of orders/transactions (Transactie_Transactienummer) that  have a value ($fOmzet)) of at least € 25,-

       

      I tried this:

       

      =SUM(if($(fOmzet)>25,COUNT(DISTINCT Transactie_Transactienummer),0))

       

      but I get the usual error: Nested aggregation not allowed.

       

      Anyone have a clever trick to get this information?