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 situtations 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

PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com