4 Replies Latest reply on Oct 15, 2018 9:19 AM by Jim Dehner

    If Statement to filter out, Task_Owner Name, when value = Equipment On-Site

    Matthew Hebert

      Created an If Then Statement to filter out Task_Owner only when Task is equal to - Equipment On-Site.
      Task and Task_Owner are fields in the DB

       

      Trying to display only the Task_Owner Name, when the Task Value = Equipment On-Site.
      If Task not Equal to Equipment On-Site, Null.

       

      IF [TASK]= 'equipment on site'

      THEN [TASK_OWNER]= [TASK_OWNER]

      IFNULL NO [TASK_OWNER]

      END