11 Replies Latest reply: Jan 30, 2017 2:56 AM by Rahul Pawar RSS

    List data only if possible values are true

    afsar shaikh

      Hi Everyone,

       

      I stucked in some logic and i need a help from you.

       

      I'm sharing an example below, which has 3 columns as Manager, Employee and Project Assigned.

      I wan't to list only those manger whose all employees have project assigned.

       

      So, in below example only Manger XYZ should be shown since, under him everyone's project assigned. Also, Manager 'ABC' shouldn't be displayed since, it has N and NULL values.

      Could anyone help me to achieve this? Thanks

       

      Manager EmployeeProject Assigned
      ABCE1Y
      ABCE2N
      ABCE3NULL
      XYZE4Y
      XYZE5Y
      XYZE6Y

       

      Regards,

      Afsar Shaikh