title: SSRS - Replacing a null value in an 'decimal' column with the 'string' message?
body: <p>I have the following table:</p>
  
  <pre><code>item_ID  |  item_Name  |  Amount
  ---------|-------------|-------
     12    |    apple    |  $1
     13    |    orange   | &lt;null&gt;
     14    |    grapes   |  $2.5
  </code></pre>
  
  <p>For the 'null' value for the 'orange' item, I'd like to replace it with the string 'N/A', even though the column the data comes from is an decimal.  Is it possible?</p>
  
  <p>I tried putting in the expression for that column as follows:</p>
  
  <pre><code>=IIF(IsNothing(Fields!Amount.Value), Sum(Fields!Amount.Value), 'N/A')
  </code></pre>
  
  <p>But I got an error and the report failed.</p>