The following is a list of all of the formula functions that 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.
- 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, ...)
- COS: COS(Angle)
- 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: GETCAALLOCATION(Index)
- GETCACOUNT: GETCACOUNT()
- GETCADOB: GETCADOB(Index)
- GETCADOD: GETCADOD(Index)
- GETCADOM: GETCADOM(Index)
- GETCAFRACTION: GETCAFRACTION("DefName")
- GETCALCINPUT: GETCALCINPUT(Code)
- GETCAMAXCERTPER: GETCAMAXCERTPER()
- GETCAMAXFRACTION: GETCAMAXFRACTION(CertPer)
- GETCAPRIORITYTYPE: GETCAPRIORITYTYPE(Index)
- GETCASEX: GETCASEX(Index)
- GETCASSN: GETCASSN(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)
- SIN: SIN(Angle)
- 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, ...)
- TAN: TAN(Angle)
- 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)
