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.

       

      Example:

       

      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?

       

      Thanks!