LOOKUP and IIF

• sharonsql2013

  SSCertifiable

  Points: 5908

  More actions

  February 26, 2014 at 11:38 pm

  #286192

  I am trying to count all decvices which are greater than 1 and count those as "1" else blank.But I am also doing a lookup at the same time.

  IIF(Lookup(Fields!device.value,Fields!Device1.value,CountName,"Dataset1")>1,1,Nothing)

  But I get an Error#. Let me know whats wrong with syntax.

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  February 27, 2014 at 12:24 am

  #1692555

  What is the error?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP