| 
 
  | 

| 
 Description  | 
 
  | 
| 
 
  | 
 
  | 
| 
 Formula  | 
 PrevMonthAvg(input)=begin NoDaysLastMo = BusDaysInAnyMonth(AddMonths(date, -1)) intSum = gapfill(rsum($1, NoDaysLastMo + first_($1))) intQuotient = Divide(rsum($1, first_($1)), NoDaysLastMo) retval = Diff(intSum, intQuotient) end  | 
| 
 
  | 
 
  | 
| 
 Parameters  | 
 INPUT 
  | 
| 
 
  | 
 
  | 
| 
 Return Value  | 
 
  | 
| 
 
  | 
 
  | 
| 
 Examples  | 
 
  | 
| 
 
  | 
 
  | 
| 
 Comments  | 
 
  | 
©2008 Aspen Research Group, Ltd. All rights reserved. Terms of Use.