5 Replies Latest reply: Jul 8, 2013 4:58 AM by test test RSS

    Check if field is null in script, in conditional statement

      Hello,

       

      I want to check if a value is Null, and if it is Null, I want to assign a value. This is what im trying:

       

      if(IsNull([Stock]), [Stock] = 1, [Stock]) as [Stock]
      

       

      Problem is, when I check the value the [Stock] = 0. So instead of making it 1 its 0.

      How can I do this different?