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