CorkscrewReversalλ() reverses its opening balance based on a timing flag. In this example, we are accruing monthly taxes until the quarter and then paying the balance as our estimated quarterly taxes.
CorkscrewReversalλ( Opening, FLow1, [Flow2], [Flow3], [Flow4], [PositiveOnly])
Opening
(Required) First period's opening balance.
ReversalFlags
(Required) A row of numbers indicating how many periods back from current to reverse. 0=no reversal this period. 1=Reverse close 1 period prior. 2=Reverse close 2 periods prior, etc.
Flow1
(Required) A row, or VSTACKed rows of values to add to opening. If a row in Flow1 is to be subtracted make the row negative.
Flow2
(Optional) A row of values to add to opening. If Flow2 is to be subtracted make the row negative.
Flow3
(Optional) A row of values to add to opening. If Flow3 is to be subtracted make the row negative.
Flow4
(Optional) A row of values to add to opening. If Flow3 is to be subtracted make the row negative.