11 Replies Latest reply: Nov 2, 2017 5:11 AM by Sunny Talwar RSS

    How to get distinct values for the fields

    kiran kumar

      Hi Experts,

       

      How to get distinct values for the fields,  i have filed called PROGRESS

      Progress -->Completed, In progress, Late, I have Student  field

       

        1. If a student is enrolled into two programs:  one is completed and other in progress : count towards IN-PROGRESS only
        2. If a student is enrolled into two programs:  one is completed and other in late : count towards LATE only
        3. If a student is enrolled into two programs:  one is late and other in progress : count towards IN-PROGRESS only

       

      How can i achive this?

       

      Name     Progress   Program

      Kiran       Complete  1

      Kiran        In Progress 2

      Vijay        Complate  1

      Anil          Inprogress  1

      Anill         Late       2

       

      kiran should count only for in progress

      anil should count for late

      vijay should count in Complete