none
SSRS 2008 Count the Number of Columns Where Value is Greater Than 0 RRS feed

  • Question

  • Is it possible to create a column in SSRS to count the number of columns in an inserted table where the value of that column is not equal to 0?

    I am basically trying to derive the average of the columns with an expression in a column created within the report.

    I have 5 columns from a table whose values can be 0 - 5.  I need to create a column to display the Average of the 5 columns where the value in that columns cell is >0.  So I only want to divide the sum of values in the columns by the total number of columns but only count a column if the value is greater than 0.

     

    Saturday, September 10, 2011 4:44 PM