Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

LOOKUP and IIF Expand / Collapse
Author
Message
Posted Wednesday, February 26, 2014 11:38 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, June 25, 2015 9:47 AM
Points: 331, Visits: 990
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.
Post #1545707
Posted Thursday, February 27, 2014 12:24 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:17 AM
Points: 14,452, Visits: 12,449
What is the error?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1545732
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse