10 Replies Latest reply on Nov 12, 2015 9:14 AM by anushachowdary.sakhamuri

    Calculations Help!!

    anushachowdary.sakhamuri

      Hi ALL,

       

      I have three Fields "Label, Feat, Char"

      Each Label has many feats and each feat has many chars.

      For Example:

      Label           Feat          Char

      abc              001           a001

                                          b001

                         002            a002

                                          b002

                                          c001

      .Even if one Char fails, the entire Label fails

      Fail/Pass :

      IF [Dev]>[upper limit ]OR [Dev]<[lower limit] THEN "Fail" else "Pass" END

       

      I need a calculation that will give me the failure rate for the Labels.

       

      Thank You!!