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

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)
  • 14: Unadjusted Earnings Unit Amount
  • 15: Unadjusted Earnings Unit Amount (used)