6 Replies Latest reply on Dec 5, 2018 1:36 AM by marian.eerens

    Calculating accuracy (%) using the count of multiple dimensions

    marian.eerens

      For a work project I need to re-create the following calculation but so far have been unable to make it work. I admit not enough knowledge of more complex calculations but working on that. In the meantime any help with getting the below to work would be much appreciated.

       

      Accuracy% =  (Number of Orders - Number of Returns with Code 5) / Number of Orders

       

      I created a sample workbook with a mock-up the data I'm working with (see attached).

      - Different types of transactions in the same table

      - Transactions have multiple lines

      - Any of the transaction may or may not have a specific code

       

      If any additional clarification is needed, let me know, first time posting asking for help so hope I gave sufficient information.

       

      Sidenote: we're currently using 10:5