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

    Calculating accuracy (%) using the count of multiple dimensions


      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