title: Nested iif statements in SSRS
body: <p>I am attempting to write a nested iif statement in SSRS that will convert the varchar values that are numbers(isnumeric) to integer and leave the text as is. I also want to be sure if the value in the cell is "0" it will return a blank or "". Please see the code I am using below. Any insights as to why the non-numeric text is showing as #Error would be greatly appreciated. Thanks!</p>
  
  <pre><code>=iif(
  Fields!O1_Parent_Line_Item_ID.Value is "0", "", iif(ISNUMERIC(Fields!O1_Parent_Line_Item_ID.Value), CInt(Fields!O1_Parent_Line_Item_ID.Value), Fields!O1_Parent_Line_Item_ID.Value))
  </code></pre>