.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Sum IIf "And" ?

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :Sql Server
 
 How do I do a sum iif with two things filtered , I need the sum for all Canine for customer 6101... I entered in the code below, but keep getting zeros across the board. I know this code works without the AND Customer Catergory part. But i need to have both of these for the sum iif. Please help!   =Sum(IIF(Fields!CANINE_FELINE.Value = "CANINE"  and Fields!CUSTOMER_CATEGORY.Value = 6101,CDBL(Fields!Item_Qty.Value),CDBl(0)))


View Complete Post


More Related Resource Links

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend