9 Replies Latest reply on Sep 26, 2018 2:31 PM by Chase Mueller

    Level of Detail Expression Help

    Chase Mueller

      I have a data set for material testing.  Each material lot has 10 tests associated with it.  If one test fails the lot is rejected.  How would you recommend I set up this expression.  This is what I have tried.

      {fixed [PO#],[Material Name (group)]: IF COUNT([Test])=(COUNT([Pass])) then "Pass" ELSE "Fail" END}

       

      Every lot has at least one test that passes.  For example if I have 3 lots that failed out of 100, my result is:  100 Pass and 3 Fail.  What I want is 97 Pass and 3 Fail.

       

      Thanks,

      Chase