3 Replies Latest reply: Jun 22, 2015 1:40 AM by Mayil Vahanan Ramasamy RSS

    I wanna show employee whose getting salary 10000 to 20000

    Abinesh Sathish

      Hi friends,


      I wanna show the employee_id whose getting salary in between 10000 to 20000 And am using this expression for that.

                                              If(((SALARY<=20000)&(SALARY>=10000)),EMPLOYEE_ID )as Grade2

      But it show me the employee id whose are getting salary below 20000 and below 10000 also ..


      Can u please help me to get my required output..