Different Calcs in Matrix Columns

• nigel.c.west

  Hall of Fame

  Points: 3468

  More actions

  May 9, 2008 at 2:20 am

  #190408

  I have a matrix report that shows Count & Average as columns against data (this is a ReportServer usage report). The issue is that the Average column should be calculated as UsageCount/NumberDays in the detail area (where number of days is the number of working days in that month), but in the sub-total area it should be calculated as the UsageCount/TotalNumberDays (where this number is the total number of working days included in the report).

  Any ideas?

  Nigel West
  UK

• xanthos

  SSCrazy

  Points: 2510

  More actions

  May 9, 2008 at 9:44 am

  #813173

  Have a look at the Inscope-function:

  Without more information it's hard to give an example but it shoud look like:

  =IIF(INSCOPE("Groupname")

  , Fields!UsageCount.value/Fields!NumberDays.value

  , Fields!UsageCount.value/Fields!TotalNumberDays.value)