The following is a list of all of the formula functions are available when coding a formula in DB Precision along with the proper syntax. To view detail on a function, click on the function name:

For a list of all of the formula operands that are available, click here.

For a list of all of the mathematical symbols that are supported in DB Precision, click here.

• ABS: ABS(Amount)
• AND: AND(Formula #1, Formula #2, Formula #3, ...)
• ANNFACTORINTERPCOMM: ANNFACTORINTERPCOMM("DefName", CalculationDate, CurrentAge, DefAge (optional), CAAge (optional), Rate1 (optional), Rate2 (optional), Rate3 (optional), PeriodCertain (optional), ContinuationPct (optional), Duration1 (optional), Duration2 (optional))
• ANNUITYFACTOR: ANNUITYFACTOR("DefName", CalculationDate, Age, CAAge (optional))
• ANNUITYINTRATE: ANNUITYINTRATE("DefName", CalculationDate, Segment)
• AVERAGE: AVERAGE(Amount #1, Amount #2, Amount #3, ...)
• CAFINTRATE: CAFINTRATE("DefName", CalculationDate, Segment)
• CALCULATE: CALCULATE("DefName", CalculationDate, DOTInd)
• CEILING: CEILING(Amount, Significance(optional))
• CHOOSE: CHOOSE(Index, Amount #1, Amount #2, Amount #3, ...)
• DATE: DATE(Month, Day, Year)
• DATEADJUST: DATEADJUST(Date, Year, Month, Day)
• DATEROUND: DATEROUND(Date, RoundType, RoundUnit, AnnivMonth, AnnivDay)
• DATEVALUE: DATEVALUE(Date)
• DAY: DAY(Date)
• DOLOOP: DOLOOP("Formula", "WhileFormula", ReturnType, ShowLoopResults (optional), "CalcDateFormula" (optional), "PaymentStartFormula" (optional), "AccountDateFormula" (optional), "SBCOFormula" (optional), "SumIfFormula" (optional))
• EXP: EXP(Amount)
• FLOOR: FLOOR(Amount, Significance (optional))
• FV: FV(InterestRate, Period, Payment, PV, AnnuityType)
• GETAVGDETAIL: GETAVGDETAIL("DefName", Date, Index, Type)
• GETBENLATEST: GETBENLATEST(Date, AmountCode, IgnoreLumpSum, IgnoreDef, DynamicInd (optional), IgnoreAnnuity (optional), Index (optional))
• GETBENLIMIT: GETBENLIMIT(Year, IncreaseRate)
• GETBENPAYSET: GETBENPAYSET("DefName", CalculationDate (optional), ACD (optional), AccountDate (optional), SBCODate (optional))
• GETCACOUNT: GETCACOUNT()
• GETCADOB: GETCADOB(Index)
• GETCADOD: GETCADOD(Index)
• GETCADOM: GETCADOM(Index)
• GETCAFRACTION: GETCAFRACTION("DefName")
• GETCALCINPUT: GETCALCINPUT(Code)
• GETCAMAXCERTPER: GETCAMAXCERTPER()
• GETCAMAXFRACTION: GETCAMAXFRACTION(CertPer)
• GETCASEX: GETCASEX(Index)
• GETCATCHUPLIMIT: GETCATCHUPLIMIT(Year, IncreaseRate)
• GETCATYPE: GETCATYPE(Index)
• GETCOMPLIMIT: GETCOMPLIMIT(Year, IncreaseRate)
• GETDCDEFLIMIT: GETDCDEFLIMIT(Year, IncreaseRate)
• GETDCLIMIT: GETDCLIMIT(Year, IncreaseRate)
• GETDETAIL: GETDETAIL("DefName", StartDate, EndDate, Type)
• GETEARLYADJUST: GETEARLYADJUST(EarlyDate, NormalDate, BasisDate, "AnnuityDef", Method)
• GETHISTDATE: GETHISTDATE(DateType, DateCode, LookupType, IgnoreEst, StartDate (optional), EndDate (optional))
• GETLATEADJUST: GETLATEADJUST(StartDate, EndDate, BasisDate, "AnnuityDef", Method)
• GETMORTRATE: GETMORTRATE("DefName", CalculationDate, AgePart, Type, AgeCA (optional))
• GETMRDDATE: GETMRDDATE()
• GETNOLOCATE: GETNOLOCATE(Code)
• GETPLANNUMBER: GETPLANNUMBER()
• GETRETAMT: GETRETAMT(StartDate, EndDate, AmountType, StateLocalCode)
• GETRPTAMT: GETRPTAMT("RptAmtName", StartDate, EndDate, MatchType, PrimaryID, SecondaryID, IncludeEst, IncludeProj, ReturnType, Value (optional), ExcludeValue (optional))
• GETSAMPLEIND: GETSAMPLEIND()
• GETSEX: GETSEX()
• GETSNAPSHOTDATE: GETSNAPSHOTDATE(LookupType)
• GETSOBDATE: GETSOBDATE()
• GETSSRD: GETSSRD(CalcType, LawYear)
• GETSTATUS: GETSTATUS(CalculationDate, LookupType)
• GETSTATUS2: GETSTATUS2(CalculationDate, LookupType)
• GETSURVFRACTION: GETSURVFRACTION("DefName", CalculationDate, AgeCurrent, AgeFuture, Type, AgeCA (optional))
• GETSVCEND: GETSVCEND("ServiceDefName", AccrualInd (optional))
• GETSVCENDLATEST: GETSVCENDLATEST("ServiceDefName")
• GETSVCSTART: GETSVCSTART("ServiceDefName")
• GETSVCSTARTLATEST: GETSVCSTARTLATEST("ServiceDefName")
• GETTAXDETAIL: GETTAXDETAIL("DefName", Type)
• GETWITHDETAIL: GETWITHDETAIL(Type, Code)
• GETUSERTYPE: GETUSERTYPE()
• GETVSTPCT: GETVSTPCT(“BPSName”, Date)
• IF: IF(FormulaTest, FormulaTrue, FormulaFalse)
• INT: INT(Amount)
• ISEMPLOYED: ISEMPLOYED(Date)
• LARGE: LARGE(Index, Amount #1, Amount #2, Amount #3, ...)
• LN: LN(Amount)
• LOG: LOG(Amount, Base)
• LOG10: LOG10(Amount)
• MAX: MAX(Amount #1, Amount #2, Amount #3, ...)
• MIN: MIN(Amount #1, Amount #2, Amount #3, ...)
• MOD: MOD(Amount, Divisor)
• MODE: MODE(Amount #1, Amount #2, Amount #3, ...)
• MONTH: MONTH(Date)
• MONTHDIFF: MONTHDIFF(StartDate, EndDate)
• NETWORKDAYS: NETWORKDAYS(StartDate, EndDate)
• NOT: NOT(Formula)
• OR: OR(Formula #1, Formula #2, Formula #3, ...)
• PI: PI( )
• PMT: PMT(InterestRate, Period, PV, FV, AnnuityType)
• POWER: POWER(Amount, Power)
• PRODUCT: PRODUCT(Amount #1, Amount #2, Amount #3, ...)
• PV: PV(InterestRate, Period, Payment, FV, AnnuityType)
• QUOTIENT: QUOTIENT(Numerator, Denominator)
• RAND: RAND( )
• ROUND: ROUND(Amount, Digits)
• ROUNDDOWN: ROUNDDOWN(Amount, Digits)
• ROUNDUP: ROUNDUP(Amount, Digits)
• RPTAMTLOOKUP: RPTAMTLOOKUP("RptAmtName", Date, MatchType, ReturnType)
• RPTAMTSUM: RPTAMTSUM("RptAmtName", StartDate, EndDate, MatchType)
• SPONSORAMTLOOKUP: SPONSORAMTLOOKUP("AmtName", Date, Employer (optional), MatchType (optional), ReturnType (optional), AdditionalKey1 (optional), AdditionalKey2 (optional))
• SQRT: SQRT(Amount)
• SUM: SUM(Amount #1, Amount #2, Amount #3, ...)
• TODAY: TODAY()
• TRUNC: TRUNC(Amount, Digits)
• TWB: TWB(Year, LawType)
• VLOOKUP: VLOOKUP(Row, "SheetName", Column)
• WEEKDAY: WEEKDAY(Date)
• WORKDAY: WORKDAY(Date, Days)
• YEAR: YEAR(Date)
• YEARFRAC: YEARFRAC(StartDate, EndDate, Basis)