2 Replies Latest reply on Jul 19, 2016 6:41 AM by David Vincent

    % of fail

    David Vincent

      I try do do a calculation for the % of fail

       

      I have different filter on the right.  If we choose one of the filter and uncheck null, they only value left are failed ones.  I want to create a calculation to find the % of fail for that value.

       

      In my example i have 10 products.  So the formula would be something like number of not null * 100 / total of products

        • 1. Re: % of fail
          Stoyko Kostov

          Hello David,

           

          Here's one way to do it.

           

          Define calculated fields for each repair type you want to measure as follows:

           

          Calculation % Fail Coupe

          SUM(

          IF(ISNULL([COUPE PLASTIQUE - RÉPARATION COMMENTAIRES]))

          THEN 0

          ELSE 1

          END)

          *100.0/[Number of Records]

           

          Calculation % Fail Tensionneur

          SUM(

          IF(ISNULL([Tensionneur Reparation Commentaires]))

          THEN 0

          ELSE 1

          END)

          *100.0/[Number of Records]

           

          and so on.

           

          (If you are unsure how to do this - right-click in the Measures pane and choose Create calculated field. Name the calculation as specified on the first line and paste the remaining lines below the name).

           

          For each calculation, right-click on the name, go to Default Properties - Total Using - and choose Average. Then drag the calculation to the tool tip.

           

          Now when you hover your mouse over the numbers in your table, you will see the failure rates reported for each repair type you defined.

           

          I'm attaching the workbook with those changes.

           

          Hope this helps - don't hesitate to ask if you have more questions.

          1 of 1 people found this helpful
          • 2. Re: % of fail
            David Vincent

            Thanks Stoyko,

             

            I think i can live with that, it will works for what i want to do

             

            Thanks for your time and your help