?? on =count adding a "When"

• jbalbo

  SSCertifiable

  Points: 7580

  More actions

  April 3, 2013 at 9:19 am

  #270590

  using this expression on a total in a matrix

  =count(Fields!xmark.Value)

  can I add a condition onto this so it only counts xmark when it = 'X' or = 'D' ?

  Thanks in Advance

  Joe

• jbalbo

  SSCertifiable

  Points: 7580

  More actions

  April 3, 2013 at 9:41 am

  #1603256

  Hey.. I actually figured it out !!! lol!!

  =sum(iif(Fields!xmark.Value ="X" or Fields!xmark.Value ="D", 1,0))

• THE-LIP

  SSChasing Mays

  Points: 655

  More actions

  April 3, 2013 at 11:21 pm

  #1603434

  It's correct !!!!!!