SSRS - Sub total counting
Posted on 2010-09-07
I have a MS SSRS report that has several columns that I want to add sub-totals to. The cells in the columns are not numbers, they are values like C11, C52, C95, etc. Each column will have the same value in some of its cells like C11. I want to count the number of cells in a column that have a value present. For example, if the first column has five of its ten cells (rows) filled with C11, I want to print the sub total of 5. If the next column has only three of the ten cells (rows) filled with C52, then I want the sub total to be 3.
What formula can I use to create a count of cells that have a value and are not blank?
I tried using this Expression but it counts all cells (rows) and not just the ones that have a value present:
=Count(Trim(Fields!Offer_Id00.Value) > "")
Thanks for the help.