10 Replies Latest reply on Sep 21, 2017 4:59 AM by rini agarwal

    Get eligible and not eligible

    rini agarwal

      Hi,

       

      I am writing Below query to achieve whether employee is eligible to qualify for next band or not.

       

      IF ([Category]='Practice Building')AND  ([Category Weightage]>30) THEN "eligible"

      ELSEIF ([Category]='Self Development')AND  ([Category Weightage]>30) THEN "eligible"

      ELSEIF ([Category]='Thought Leadership')AND  ([Category Weightage]>40) THEN "eligible"

      else "Not Eligible"

      END

       

      By writing above query i am not able to get the required output.

       

      Can anyone please help

       

      Thanks,

      Rini