expression issues

• fliu2265

  SSC Eights!

  Points: 818

  More actions

  January 16, 2015 at 12:51 pm

  #313756

  Hello,

  I have one following expression:

  =count(IIF(Fields!degreeAttain.Value = "Yes", Fields!SSN.Value, nothing) )

  The result is 0, but I checked the data and I saw "Yes" and "No" for degreeAttain.

  I do not get it. Please help.

  Thanks

• AndrewDBA

  Old Hand

  Points: 372

  More actions

  January 22, 2015 at 7:31 pm

  #1772461

  Your expression is correct. Are you able to paste the SELECT statement and the query results when ran in SSMS?

• Shawn Melton

  SSC-Insane

  Points: 24685

  More actions

  January 22, 2015 at 8:04 pm

  #1772467

  fliu2265 (1/16/2015)

  ---

  Hello,

  I have one following expression:

  =count(IIF(Fields!degreeAttain.Value = "Yes", Fields!SSN.Value, nothing) )

  The result is 0, but I checked the data and I saw "Yes" and "No" for degreeAttain.

  I do not get it. Please help.

  Thanks

  If I use a dataset as this with your expression it comes out to 12:

  SELECT 'Yes' AS degreeAttain, 0 AS 'SSN'

  UNION

  SELECT 'Yes' AS degreeAttain, 1 AS 'SSN'

  UNION

  SELECT 'Yes' AS degreeAttain, 2 AS 'SSN'

  UNION

  SELECT 'Yes' AS degreeAttain, 3 AS 'SSN'

  UNION

  SELECT 'No' AS degreeAttain, 4 AS 'SSN'

  UNION

  SELECT 'Yes' AS degreeAttain, 5 AS 'SSN'

  UNION

  SELECT 'Yes' AS degreeAttain, 6 AS 'SSN'

  UNION

  SELECT 'Yes' AS degreeAttain, 7 AS 'SSN'

  UNION

  SELECT 'Yes' AS degreeAttain, 8 AS 'SSN'

  UNION

  SELECT 'No' AS degreeAttain, 9 AS 'SSN'

  UNION

  SELECT 'Yes' AS degreeAttain, 10 AS 'SSN'

  UNION

  SELECT 'Yes' AS degreeAttain, 11 AS 'SSN'

  UNION

  SELECT 'No' AS degreeAttain, 12 AS 'SSN'

  UNION

  SELECT 'Yes' AS degreeAttain, 13 AS 'SSN'

  UNION

  SELECT 'Yes' AS degreeAttain, 14 AS 'SSN'

  Shawn Melton
  Twitter: @wsmelton
  Blog: wsmelton.github.com
  Github: wsmelton