Calculated field error in ssrs

• carl.meads

  Mr or Mrs. 500

  Points: 519

  More actions

  September 13, 2011 at 5:29 am

  #247788

  I have the following expression:

  =iif(isnothing(reportitems.textbox1.value),1,2) which works fine, however when I switch the false statement to,... reportitems.textbox2.value/reportitems.textbox1.value to read:

  =iif(isnothing(reportitems.textbox1.value),1,reportitems.textbox2.value/reportitems.textbox1.value) it seems to ignore the isnothing part and I get #error.

  Any ideas why this is?

  Thanks

  Carl.

• HowardW

  One Orange Chip

  Points: 29109

  More actions

  September 13, 2011 at 5:47 am

  #1380531

  Duplicate:

  http://www.sqlservercentral.com/Forums/Topic1174014-391-1.aspx