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:

Some formula functions contain optional parameters that are noted as such with an (optional) designation. This means that if a function contains seven inputs, and three are optional, you may enter anywhere from four to seven inputs in the function. For example, GETBENLATEST(0, 0, 0, 1) and GETBENLATEST(0, 0, 0, 1, 0, 0, 2) are viable functions in DBP. If you wish to use an optional input, you must fill in all optional inputs to the left of that input with a value. Therefore, GETBENLATEST (0, 0, 0, 1, , , 2) is not a viable function.

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))
• GETCAALLOCATION: GETCAALOCATION(Index)
• GETCACOUNT: GETCACOUNT()
• GETCADOB: GETCADOB(Index)
• GETCADOD: GETCADOD(Index)
• GETCADOM: GETCADOM(Index)
• GETCAFRACTION: GETCAFRACTION("DefName")
• GETCALCINPUT: GETCALCINPUT(Code)
• GETCAMAXCERTPER: GETCAMAXCERTPER()
• GETCAMAXFRACTION: GETCAMAXFRACTION(CertPer)
• GETCAPRIORITYTYPE: GETCAPRIORITYTPE(Index)
• 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, MeasDate (optional))
• 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)
• GETPIADETAIL: GETPIADETAIL("DefName", EndDate, Type, MeasDate (optional))
• GETPLANNUMBER: GETPLANNUMBER()
• GETRETAMT: GETRETAMT(StartDate, EndDate, AmountType, StateLocalCode)
• GETRPTAMT: GETRPTAMT("RptAmtName", StartDate, EndDate, MatchType, PrimaryID, SecondaryID, IncludeEst, IncludeProj, ReturnType, Value (optional), ExcludeValue (optional), DateReceivedStart (optional), DateReceivedEnd (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)