Conditional sum in reporting services -- sql server reporting services

chetanasamal NO[at]SPAM gmail.com
8/29/2007 11:18:29 AM

I need to find a conditional sum of sales if fields!Example.value = 0
(And same if fields!Example.value = 1)

How do I do that in reporting services?

Thanks

CS

Michael C
8/29/2007 4:08:01 PM

=Sum(IIf(Fields!Example.value=0,0,Fields!Example.Value))

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Conditional sum in reporting services