14 Replies Latest reply: Sep 27, 2012 8:56 AM by Nienke de Jong RSS

    Sum if

      I need to make a sum for different options.




      The order for account A is 10. We have failed to deliver 1, which is marked as "failed". (in the tabel 2 rows, commom dimensions are accountnr and ordernr)

      The order for account B is 100. We have delivered all.


      I need the following result:


                          Ordered     Delivered     Not delivered

      Account A     10               9               1

      Account B     100          100               0


      How can I proceed? Best to use Rowno or Recno? Or something else?