title: SSRS calculating IF THEN ELSE with nulls
body: <p>I am trying to create a calculated field in an SSRS dataset but the fields that need to summed also have nulls and I can't get the formula correct.  Below is a description of what I am trying to do</p>
  
  <pre><code>If value.field1 = 1 and value.field2 is not null, then
      use value.field2
  otherwise
      use value.field3
  </code></pre>
  
  <p>I am sure there is a simple answer to this, but I am very new to SSRS and can't seem to find the right answer.</p>