title: How do I replace NULL with zero in an SSIS expression?
body: <p>I have two columns <code>ActivityCount</code> and <code>ParentValue</code>. I created an expression: </p>
  
  <pre><code>ROUND((ActivityCount / ParentValue) / 100,16) * 100 
  </code></pre>
  
  <p>But the problem is it returns <code>NULL</code> for some columns and I wanted to replace <code>NULL</code> with <code>0</code>. I can't seem to find the answers. </p>