Giving Average when Collapsed,actual values when Expanded?

• Wajih ul Hasan

  SSC Veteran

  Points: 265

  More actions

  July 12, 2005 at 1:51 am

  #114353

  I am trying to display the unEmployment rates for a particular state based on the Time Dimension. The months are "hidden" till the quarter is expanded. Now,the value i need to display while the Quarters are collapsed is the AVERAGE unemployment rate for the 3 months in that particular quarter..If i try to enter the expression ,

  =Sum(Fields!Measures_Un_Employment_Rate.Value)/3

  it displays the average correctly but when i expand it,the values for individual months are also divided by 3 hence giving the wrong value...if i use the expression...

  =First(Fields!Measures_Un_Employment_Rate.Value)

  it displays the values for individual months correctly,but when the quarters are collapsed, it displays the value for the first month of that quarter and not the average...

  is there any way around this problem?

   

  thanx!

• Wajih ul Hasan

  SSC Veteran

  Points: 265

  More actions

  July 12, 2005 at 2:10 am

  #573256

  ooops...i didnt know that there was a keyword by the name of Avg

  =Avg(Fields!Measures_Un_Employment_Rate.Value)

  did it for me..  just posting it here so that anyone else facing this problem might benefit...