March 18, 2009 at 10:06 am
I want to do a sum in the group footer based off values from another field. This what I have but its doing a sum of all the rows. I need to sum up where billable = Yes only.
=iif(Fields!billable.Value = "Yes", sum(Fields!document_count.Value), 0)
March 18, 2009 at 2:17 pm
Sorry nothing in front of me right now to test this but I would imagine this could work....
=sum(iif(Fields!billable.Value = "Yes", Fields!document_count.Value, 0))
Basically, you're checking to see if a single value is yes, so only deal with that single value...
By summing the results of your IIF Statement I beleive you should get the required results...
-Luke.
March 18, 2009 at 2:30 pm
thanks, that worked!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply