|
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.