2 Replies Latest reply: Oct 1, 2016 7:33 AM by Arjin Ram Korrapati RSS

    Writing Multiple IF Condition with Sum aggregate

    Arjin Ram Korrapati

      Hi All,

       

      I Need help with below requirement.

       

      Data:  

      TeamProcessActualTotalStandard
      MTVECOM4010050%
      MTVDTCKT609050%
      LOAMLOTICKT9016050%
      LOAMLODRAFT12020050%

       

       

      Requirement : Want to Create a text box to show number of teams that met standard (i need the output in team level).


      Condition: If 2 process of a team meets Standard( Actual/Total>=50%) then Teamstd count will be 1, else if only 1 team meets standard(>=50%) then it will be Teamstd counted as 0.

       

      Explanation : In the above table for TEAM="MTV" only 1 team [ DTCKT Actual/Total >=50]  where as in TEAM="LOAM" for 2 process  Actual/Total <=50% so in the text box i want to show 1/2 (it says only 1 team out of 2 has 100% Success rate).

       

       

      Please help.

       

       

      Thanks in advance.

      Arjin.