Having trouble with an IIF statement

• Richard Sabbara

  Ten Centuries

  Points: 1382

  More actions

  December 13, 2007 at 1:21 pm

  #377463

  I have the following nested iff:

  =iif(Fields!Indicator.Value Like "%Total%","",iif(Fields!ID__Of_Eligible_Members.Value =Fields!Goal.Value,"Yes","No")))

  What I want to say is if the field Indicator contains the word total then leave the field blank, if the number of eligiable members if <=6 then "N/A", if the calculation is greater than the value in the goal column, then print Yes, otherwise No in the field.

  With the exception of the first part of this that deals with the Totals issue, this works fine, what am I doing wrong?

  I tried changing the like to an equal statement and the value in the indicator field to equal total and I am still having issues.

• Richard Sabbara

  Ten Centuries

  Points: 1382

  More actions

  December 13, 2007 at 1:50 pm

  #760014

  I figured it out, when doing a like statement, it's case sensistive :(.