first_

Description

Formula

first_(series)=if(chart(chart(($1.time),30,2,100,0,1) == chart(($1.time[1]),30,2,100,0,1)[-1],1,2,100,0,1), 1, if($1[1] == nonum, first_[1], first_[1]+1))

Parameters

Return Value

Examples

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

Comments