8 Replies Latest reply: May 10, 2018 5:38 AM by Sumit Kulkarni RSS

    If/And condition

    Santhosh Ashokkumar

      Am trying to get the ID numbers where Date field should be empty and result field should be Pass. I am trying to do this within Data Manager.

       

      if([Date]='Null' and [Result]='Pass','Null', ID)

       

      Getting error near the ' ) ' .  Can someone help me out.

       

      Thanks,

      SAK