GETRETAMT

Determines the total amount of benefits paid between the start date and end date specified (based upon benefit payment information stored for a person).

Formula Syntax

GETRETAMT(StartDate, EndDate, AmountType, StateLocalCode)

StartDate: Date from which amount is to be measured. This may be a fixed date such as DATE(1,1,2015) or system date such as CALCDATE.

EndDate: Date to which amount is to be measured. This may be a fixed date such as DATE(1,1,2015) or system date such as CALCDATE.

AmountType: please refer to the following to determine amount type to use:

  • 0: Gross retirement benefit
  • 1: Non-taxable benefit
  • 2: Taxable benefit
  • 3: Federal withholding
  • 4: State withholding
  • 5: Local withholding
  • 6: Medical withholding
  • 7: Other withholding
  • 8: Net benefit amount
  • 9: Final non-taxable payment date

StateLocalCode: not used. Enter 0 for now.

Examples

GETRETAMT(ACD, CALCDATEINPUT, 0, 0) returns the total gross retirement benefit paid since ACD as of the calculation date.

PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com