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

    sum with if not exist

    Christian Wunder

      Hi,

       

      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?

       

      Regards

      Christian