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?