11 Replies Latest reply: Aug 28, 2015 1:13 AM by Christian Wunder RSS

    sum with if not exist

    Christian Wunder



      I have the following table: (Excel: TESTCW_NL)


      Now I want to get only the order "123", because in this order is no Discountnumber 4.

      So for example, the formula have to look something like this

      sum(if( aggr(Discountnumer, Order)<>4, Amount)


      Can anyone help me?