14 Replies Latest reply: Mar 15, 2018 4:56 AM by Sunny Talwar RSS

    EXPRESSION TO CHECK MULTIPLE RECORDS WITH DIFFERENT VALUES

    Kalyan Chakravarthy

      Hi all

      I have below data in table and  need a expression

      To check if any one record for "result column"  having passed value than finalresult is Promoted or failed

      for student id

       

      studentid  sub    result       finalresult

      1                s1     passed

      1                s2     failed

      1                s3    passed

      2                s1    failed

      2                s3   passed

      3                s1   passed

      3                s2   passed

      3                s3   passed

      4                s1   failed

      4               s2   failed

      4               s3   failed

      Need below finalresult for each student ID

      Studentid:1 ->>> atleast one subject passed hence finalresult "promoted"

      2->>same as 1

      3->> all subjects passed hence "promoted"

      4->> final result:"Failed"

       

      Please help to write expression to get above result

      thank you