6 Replies Latest reply on Feb 27, 2013 5:37 PM by Tracy Rodgers

    Convert Null/Blank values to 0s

      I have been trying to figure out how to change ‘NULL’ values to ‘0’s. I tried using “IF ISNULL”, “IIF”, "ZN" and a couple of others but all in vain. For some reason, it’s not converting the NULLs to 0s.

       

      I would appreciate if someone could let me know how to find a solution to this. Thanks!