Count

• sharonsql2013

  SSCertifiable

  Points: 5908

  More actions

  February 4, 2014 at 9:41 am

  #283129

  I am trying to write an expression in report builder to count all device name that are duplicates or >1

  Can anyone advise

  Something like :

  P.S : device Name is Varchar

  =IIF(Count(Fields!Devicename)>1

  then show the count say 2 or 3 or whatever

  else say Null.

  I tried this :

  IIf(Count(Fields!Device_Name.Value)>1,Count(Fields!Device_Name.Value),"0")

  But I get the count "1" as well. Which I do not want....

  Then For the final SUm it should just calculate all the devicenames >1