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

    Check if field is null in script, in conditional statement



      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?