PRIOR() function
Shift data across time periods within a roll forward loop
Rob Markwell
Last Update 4 tháng trước
Prior formula is the custom formula, it allows the user to fetch previous time period indicator value and the time period can be specified by the user.
The functionality of the Prior function is the same as that of the Shift function, however it is designed to work within blocks with a Roll forward time loop.
“Indicator name” : string. Name of the indicator to shift
number_of_periods : number or reference to another indicator - number of periods to shift the values
Assuming the model is monthly - the “6” indicator 2 will fetch value 6 months prior to the current month
The first 6 months of Indicator 2 are filled with 0 as the value.
Formula - Prior(“Indicator 1”, 6)
