title: Crystal Reports If true then return number else return NULL
body: <p>In Crystal Reports, is it possible to have a function that returns a numeric value if the if statement evaluates to true and returns NULL otherwise?</p>
  
  <p>I currently have</p>
  
  <pre><code>IF ({INDICATOR} = 'Y') Then
  (
      {numeric value}
  )
  Else
  (
      0
  );
  </code></pre>
  
  <p>But since 0 is a possible value of {numeric value} it doesn't make sense. Rather, I would rather have that field come up blank if the indicator isn't 'Y', but when I replace the 0 with NULL it gives me a type mismatch error.</p>
  
  <p>Is there a way for me to only show the value when the indicator is 'Y'?</p>