Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, September 27, 2016 8:47 AM
Points: 405, Visits: 1,212
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 9:52 AM
Points: 15,398, Visits: 13,124
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 SQLKover.

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

Add to briefcase

Permissions Expand / Collapse