GETAVGDETAIL

Returns the requested detail type for the specified average earnings definition.

Formula Syntax

GETAVGDETAIL("DefName", Date, Index, Type)

"DefName": the name of the item for which you need additional detail. This name must be enclosed in quotes.

Date: the date as of which the detail should be returned. Enter 0 here if as of the calculation date.

Index: the index of the detail to be extracted (enter 0 for types 0, 1, or 2) where 1 is the latest detail.

Type: refer to the following to determine the type to use:

  • 0: Averaging Period
  • 1: Lookback Period
  • 2: Earnings Sum
  • 3: Earnings Unit Amount
  • 4: Earnings Unit Effective Date
  • 5: Earnings Unit Stop Date
  • 6: Earnings Unit Maximum
  • 7: Earnings Unit Period
  • 8: Earnings Unit Used Indicator
  • 9: Earnings Unit Amount (used)
  • 10: Earnings Unit Effective Date (used)
  • 11: Earnings Unit Stop Date (used)
  • 12: Earnings Unit Maximum (used)
  • 13: Earnings Unit Period (used)
PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com