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)