SSRS - is it possible to do a conditional summary?

• Animal Magic

  SSChampion

  Points: 13964

  More actions

  October 8, 2009 at 2:21 am

  #216144

  Hi All,

  I am trying to create a running total which only includes certain values. For ease lets just say i want to average all the values where the value is not 0. In crystal it was easy but i cant find the equivalant in SSRS.

  If anyone could help i would be very grateful

  John

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  October 8, 2009 at 6:18 pm

  #1063811

  I believe something like this is how you'd do it:

  =Sum(fields!name.value)/Sum(If(fields!name.value = 0, 0, 1),

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question