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
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 1:01 PM
Points: 215, Visits: 639
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 @ 10:26 AM
Points: 13,359, Visits: 10,223
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