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.