Formula Methods

This is a list of the methods available for you to use when creating payroll formulas. Commands are used along with the variables to set the values to bring into the formulas.

Refer to the Writing Formulas for information on formula variables, operations, and functions.

Command Description
f.GetNumericVariable(name) Bring a numeric variable value into the formula.
f.SetNumericVariable(name, value) Set the numeric variable value that has been calculated to bring the value into the calculated check.
f.GetTextVariable(name) Bring a variable that contains a text value into the formula.
f.SetTextVariable(name, value) Set the text variable value that has been calculated to bring the text into the calculated check.
f.GradientValue(value, column) Bring the value from a table that has graduated rows into the formula.
f.TableValue(row, column) Bring the value from a table that does not have graduated rows into the formula.
f.EmployeeTaxEarnings(id, state, local) Employee Taxable earnings from current check.
f.EmployeeTaxEarningsYTD(id, state, local) Employee YTD taxable earnings.
f.EmployeeTaxEarningsMTD(id, state, local) Employee MTD taxable earnings.
f.EmployerTaxEarnings(id, state, local) Employer Taxable earnings from current check.
f.EmployerTaxEarningsYTD(id, state, local) Employer YTD taxable earnings.
f.EmployerTaxEarningsMTD(id, state, local) Employer MTD taxable earnings.
f.Earning(id) Bring in the amount calculated on the check for a specific earning code.
f.EarningMTD(id) Bring in the amount month to date for a specific earning code.
f.EarningYTD(id) Bring in the amount year to date for a specific earning code.
f.Deduction(id) Bring in the amount calculated on the check for a specific deduction code.
f.DeductionMTD(id) Bring in the amount month to date for a specific deduction code.
f.DeductionYTD(id) Bring in the amount year to date for a specific deduction code.
f.Withholding(id, state, local) Bring in the amount calculated on the check for a specific withholding code.
f.WithholdingMTD(id) Bring in the amount month to date for a specific withholding code.
f.WithholdingYTD(id, state, local) Bring in the amount year to date for a specific withholding code.
f.CostMTD(id) Bring in the amount month to date for employer cost.
f.Tax(id, state, local) Bring in the amount month to date for employer tax.
f.TaxMTD(id, state, local) Bring in the amount month to date for employer tax.
f.TaxYTD(id, state, local) Bring in the amount month to date for employer tax.