title: Crystal Reports formula with NULL values
body: <p>I am using Crystal Reports 2008.</p>
  
  <p>I am having issues getting the Syntax correct for a formula.</p>
  
  <p>The report is grouped by customers. I have 2 commands. The first one will always have a value but the second one has a value for some of the customers but not all.</p>
  
  <p>What I need to do is write a formula that will use just a value of the first command if the second command does not have a value for that customer. If the second command does have a value then it should take the sum of command one and two.</p>
  
  <p>I have tried it like this:</p>
  
  <pre><code>IF ISNULL({Command_2.fin_bal_60}) THEN
  
    {Command_1.inv_bal_60}
  
  ELSE
  
    {Command_1.inv_bal_60} + {Command_2.fin_bal_60}
  </code></pre>
  
  <p>That is not working because when I put it into the report it only shows the records that have a value in command_2.</p>
  
  <p>I am trying to figure out how to write this so even if command_2 does not return a value it just uses command_1.</p>
  
  <p>Any help on this would be great.</p>
  
  <p>Thanks in advance.</p>