@HspOffsetIdx

This function returns the pointer data which is the nth distinct value (where n is the offset for that data), and gets the relevant row based on the date array.

This custom function uses Oracle Hyperion Public Sector Planning and Budgeting applications for a specific purpose.

Syntax

@HspOffsetIdx(DataList, StartDateList, EndDateList, BaseValue, OffSet, BaseDate)

Parameter
DataList
StartDateList
EndDateList
BaseValue
OffSet
BaseDate