Request Help with Expression to calculate %
Hello SSRS experts! I need help with an expression.
Group Header - I need the expression to be:
CountNumberofDetail rows / # of detail rows with number=1.
So for this example 4/2. I don't know how to get the denominator (2) in the group header expression.
Detail row 1 - number=1
Detail row 2 - number=2
Detail row 3 - number=1
Detail row 4 - number=3
Help is much appreaciated!!!Linda
May 9th, 2011 12:18pm
SUM(IIF(Fields!number.Value = 1, 1, 0))
Remember to mark as an answer if this post has helped you.
Free Windows Admin Tool Kit Click here and download it now
May 9th, 2011 1:00pm
This topic is archived. No further replies will be accepted.
Other recent topics
