Computing average for previous two weeks

• floresg2

  Old Hand

  Points: 337

  More actions

  April 28, 2011 at 9:59 am

  #249480

  I have my report in BIDS like this

  Absences

  4/1/2011 4/8/2011 4/15/2011 ... 6/10/2011 6/17/2011 Average Two week average

  42 53 1 3 2 (how to compute this?)

  I can get the total average just fine. I'm not sure how I can work with expressions to calculate the average for the two previous weeks.

• syedathariqbal

  Hall of Fame

  Points: 3175

  More actions

  May 2, 2011 at 3:52 am

  #1318320

  Hi,

  Before anything else, can you tell me how are you calculating Average and Two week average?

  How you got a value of 2 for two week avg?

  Regards,

  Athar