GETCALCINPUT

Returns the calculation input for the specified code.

Formula Syntax

GETCALCINPUT(Code)

  • Code: refer to the following list for a description of codes.
    • 1: Salary Scale Override
    • 2: DC Contribution Rate
    • 3: DC Rate of Return
    • 4: DC Account Balance
    • 5: DC Account Balance Date
    • 6: TWB Projection Rate
    • 7: Compensation Limit (401(a)(17)) Projection Rate
    • 8: Benefit Limit (415(b)) Projection Rate
    • 9: User-specified Calculation Date: note that while this is generally equal to CALCDATEINPUT, there are some situations such as when using the CALCULATE function where CALCDATEINPUT will not reflect the actual date entered.
Examples
  • GETCALCINPUT(1): will return the Salary Scale Override input into the calculation screen
  • GETCALCINPUT(5): will return the DC Account Balance Date input into the calculation screen
Related Topics
PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com