PrevMonthAvg

See Also...

Related Topics

 

 

 

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.