Some functions have differences in functionality, or are not available, in Polaris.
Title | Syntax | Description |
---|---|---|
ABS Numeric Functions | ABS(Number) | The ABS function returns the absolute value of a number. The absolute value of zero or a positive number remains the same. The absolute value of a negative number is the same number without the negative sign (the positive version). |
ADDMONTHS Time and Date Functions | ADDMONTHS(Date, number) | |
ADDYEARS Time and Date Functions | ADDYEARS(Date, number) | |
AGENTS Call Center Planning Functions | AGENTS(SLA, Target response time, Arrival rate, Average duration) | |
AGENTSB Call Center Planning Functions | AGENTSB(SLA, Arrival rate, Average duration) | |
ALL Aggregation Functions | Source[ALL: Mapping, ALL: Mapping 2, etc.] | |
ANSWERTIME Call Center Planning Functions | ANSWERTIME(Number of servers, SLA, Arrival rate, Average duration) | |
ANY Aggregation Functions | Source[ANY: Mapping, ANY: Mapping 2, etc.] | |
ARRIVALRATE Call Center Planning Functions | ARRIVALRATE(Number of servers, SLA, Target response time, Average duration) | |
AVERAGE Aggregation Functions | Values to average[AVERAGE: Mapping, AVERAGE: Mapping 2, etc.] | |
AVGDURATION Call Center Planning Functions | AVGDURATION(Number of servers, SLA, Target response time, Arrival rate) | |
AVGWAIT Call Center Planning Functions | AVGWAIT(Number of servers, Arrival rate, Average duration) | |
CODE Miscellaneous Functions | CODE(Item) | |
COLLECT Miscellaneous Functions | COLLECT() | |
COMPARE Logical Functions | COMPARE(Text to compare 1, Text to compare 2 [, Comparison mode] [, Locale]) | |
COUPDAYBS Financial Functions | COUPDAYBS(Settlement, Maturity, Frequency[, Basis]) | |
COUPDAYS Financial Functions | COUPDAYS(Settlement, Maturity, Frequency[, basis]) | |
COUPDAYSNC Financial Functions | COUPDAYBS(Settlement, Maturity, Frequency[, basis]) | |
COUPNCD Financial Functions | COUPNCD(Settlement, Maturity, Frequency) | |
COUPNUM Financial Functions | COUPNUM(Settlement, Maturity, Frequency) | |
COUPPCD Financial Functions | COUPPCD(Settlement, Maturity, Frequency) | |
CUMIPMT Financial Functions | CUMIPMT(Interest rate, Number of periods, Principal, Start period, End period [, Timing]) | |
CUMPRINC Financial Functions | CUMPRINC(Interest rate, Number of periods, Loan balance, Start period, End period [, Timing]) | |
CUMULATE Time and Date Functions | CUMULATE (Values to add [, Boolean] [, List]) | |
CURRENTPERIODEND Time and Date Functions | CURRENTPERIODEND() | |
CURRENTPERIODSTART Time and Date Functions | CURRENTPERIODSTART() | |
CURRENTVERSION Miscellaneous Functions | CURRENTVERSION(Line item) | |
DATE Time and Date Functions | DATE(Year, Month, Day) | |
DAY Time and Date Functions | DAY(Date) | |
DAYS Time and Date Functions | DAYS([Period]) | |
DAYSINMONTH Time and Date Functions | DAYSINMONTH(Year, Month) | |
DAYSINYEAR Time and Date Functions | DAYINYEAR(Year) | |
DECUMULATE Time and Date Functions | DECUMULATE(Value to subtract) | |
DIVIDE Numeric Functions | DIVIDE(Dividend, Divisor) | |
DURATION Financial Functions | DURATION(Settlement, Maturity, Rate, Yield, Frequency [, Basis]) | |
END Time and Date Functions | END([Time period]) | |
ERLANGB Call Center Planning Functions | ERLANGB(Number of servers, Arrival rate, Average duration) | |
ERLANGC Call Center Planning Functions | ERLANGC(Number of servers, Arrival rate, Average duration) | |
EXP Numeric Functions | EXP(Number) | |
FIND Text Functions | FIND(Text to find, Text to search [, Starting character]) | |
FINDITEM Miscellaneous Functions | FINDITEM(List or Time, Item to find) | |
FIRSTNONBLANK Aggregation Functions | Line item to search [FIRSTNONBLANK: Mapping, FIRSTNONBLANK: Mapping 2, etc.] | |
FIRSTNONZERO Numeric Functions | FIRSTNONZERO(Value 1, Value 2, [etc.]) | |
FV Financial Functions | FV(Interest rate, Number of periods, Payments [, Present value] [, Payment timing]) | |
HALFYEARTODATE Time and Date Functions | HALFYEARTODATE(Line item to cumulate) | |
HALFYEARVALUE Time and Date Functions | HALFYEARVALUE(Line item) | |
IF THEN ELSE Logical Functions | IF Boolean argument THEN Result 1 ELSE Result 2 | |
INPERIOD Time and Date Functions | INPERIOD(Date to test, Time period) | |
IPMT Financial Functions | IPMT(Interest rate, Period to examine, Number of periods, Present value [, Future value] [, Payment timing]) | |
IRR Financial Functions | IRR(Cash flow [, Estimate]) | |
ISACTUALVERSION Logical Functions | ISACTUALVERSION() | |
ISANCESTOR Logical Functions | ISANCESTOR(Ancestor, Descendant) | The ISANCESTOR function takes two list or time period values. It returns a Boolean value of TRUE if the first is an ancestor of the second. Ancestors of an item are its parent, its parent's parent, and so on. |
ISBLANK Logical Functions | ISBLANK(Value to test) | |
ISCURRENTVERSION Logical Functions | ISCURRENTVERSION() | |
ISFIRSTOCCURRENCE Logical Functions | ISFIRSTOCCURRENCE(Values to compare, List dimension to search) | |
ISNOTBLANK Logical Functions | ISNOTBLANK(Value to test) | |
ITEM Miscellaneous Functions | ITEM(List or Time) | |
LAG Time and Date Functions | LAG(Value to offset, Offset amount, Substitute value [, Non-positive behavior]) | |
LASTNONBLANK Aggregation Functions | Line item to search[LASTNONBLANK: Mapping, LASTNONBLANK: Mapping 2, etc.] | |
LEAD Time and Date Functions | LEAD(Value to offset, Offset amount, Substitute value [, Non-positive behavior]) | |
LEFT Text Functions | LEFT(Text [, Number of characters]) | |
LENGTH Text Functions | LENGTH(Text to evaluate) | |
LN Numeric Functions | LN(Number) | |
LOG Numeric Functions | LOG(Number, Base) | |
LOOKUP Logical Functions | Values to lookup[LOOKUP: Mapping, LOOKUP: Mapping 2] | |
LOWER Text Functions | LOWER(Text [, Locale]) | |
MAILTO Text Functions | MAILTO(Display text, To [, CC] [, BCC] [, Subject] [, Body text]) | |
MAKELINK Text Functions | MAKELINK(Display text, URL) | |
MAX Aggregation Functions | Source[MAX: Mapping, MAX: Mapping 2, etc.] | |
MAX Numeric Functions | MAX(Value to compare, Value to compare 2, [etc.]) | |
MDURATION Financial Functions | MDURATION(Settlement, Maturity, Rate, Yield, frequency [, basis]) | |
MID Text Functions | MID(Text, Start position [, Number of characters]) | |
MIN Aggregation Functions | Source[MIN: Mapping, MIN: Mapping 2, etc.] | |
MIN Numeric Functions | MIN(Value to compare, Value to compare 2, [etc.]) | |
MOD Numeric Functions | MOD(Dividend, Divisor) | |
MONTH Time and Date Functions | MONTH(Value to convert, [Time period method]) | |
MONTHTODATE Time and Date Functions | MONTHTODATE(Line item to aggregate) | |
MONTHVALUE Time and Date Functions | MONTHVALUE(Line item) | |
MOVINGSUM Time and Date Functions | MOVINGSUM(Line item to aggregate [, Start period] [, End period] [, Aggregation method]) | |
MROUND Numeric Functions | MROUND(Number to round [, Multiple to round to] [, Rounding direction]) | |
NAME Text Functions | NAME(List item) | |
NEXT Time and Date Functions | NEXT(Expression) | |
NEXTVERSION Miscellaneous Functions | NEXTVERSION(Expression) | |
NPER Financial Functions | NPER(Interest rate, Payments, Present value [, Residual value] [, Timing]) | |
NPV Financial Functions | NPV(Discount rate, Cash flow, Dates, Transactions) | |
OFFSET Time and Date Functions | OFFSET(Value to offset, Offset amount, Substitute value) | |
PARENT Miscellaneous Functions | PARENT(Child value) | |
PERIOD Time and Date Functions | PERIOD(Date) | |
PMT Financial Functions | PMT(Interest rate, Number of periods, Present value [, Future value] [, Timing]) | |
POST Time and Date Functions | POST(Value to post, Offset amount) | |
POWER Numeric Functions | POWER(Number, Power) | |
PPMT Financial Functions | PPMT(Interest rate, Period to examine, Number of periods, Present value [, Future value] [, Timing]) | |
PREVIOUS Time and Date Functions | PREVIOUS(Expression) | |
PREVIOUSVERSION Miscellaneous Functions | PREVIOUSVERSION(Expression) | |
PRICE Financial Functions | PRICE(Settlement, Maturity, Rate, Yield, Redemption, Frequency[, Basis]) | |
PROFILE Time and Date Functions | PROFILE(Number to change, Profile) | |
PV Financial Functions | PV(Interest rate, Number of periods, Payments, Future value, Payment timing) | |
QUARTERTODATE Time and Date Functions | QUARTERTODATE(Line item to aggregate) | |
QUARTERVALUE Time and Date Functions | QUARTERVALUE(Line item) | |
RANK Miscellaneous Functions | RANK(Source values [, Direction] [, Equal value behavior] [, Include value] [, Ranking groups]) | |
RANKCUMULATE Miscellaneous Functions | RANKCUMULATE(Cumulation values, Ranking values [, Direction] [, Include value] [, Ranking groups]) | |
RATE Financial Functions | RATE(Number of periods, Payments, Present value[, Future value] [, Payment timing] [ ,Rate estimate]) | |
RIGHT Text Functions | RIGHT(Text [, Number of characters]) | |
ROUND Numeric Functions | ROUND(Number to round [, Number of decimal places] [, Rounding direction] [, Rounding method]) | |
SELECT Logical Functions | Source[SELECT: Target item] | |
SIGN Numeric Functions | SIGN(Number) | |
SLA Call Center Planning Functions | SLA(Number of servers, Target response time, Arrival rate, Average duration) | |
SPREAD Time and Date Functions | SPREAD(Value to divide, Number of time periods) | |
SQRT Numeric Functions | SQRT(Number) | |
START Time and Date Functions | START(Time period) | |
SUBSTITUTE Text Functions | SUBSTITUTE(Text to search in, Text to find, Replacement text) | |
SUM Aggregation Functions | Values to sum[SUM: Mapping, SUM: Mapping 2, etc.] | |
TEXT Text Functions | TEXT(Number to convert) | |
TEXTLIST Aggregation Functions | Values to list[TEXTLIST: Mapping, TEXTLIST: Mapping 2, etc.] | |
TEXTLIST Text Functions | TEXTLIST(Text to concatenate, Separator, List to reference [, Duplicate behavior]) | |
TIMESUM Time and Date Functions | TIMESUM(Line item to aggregate [, Start period] [, End period] [, Aggregation method]) | |
TRIM Text Functions | TRIM(Text) | |
UPPER Text Functions | UPPER(Text [, Locale]) | |
VALUE Miscellaneous Functions | VALUE(Value to convert) | |
WEEKDAY Time and Date Functions | WEEKDAY(Date [, First day of the week]) | |
WEEKTODATE Time and Date Functions | WEEKTODATE(Line item to aggregate) | |
WEEKVALUE Time and Date Functions | WEEKVALUE(Line item) | |
YEAR Time and Date Functions | YEAR(Value to convert, [Time period method]) | |
YEARFRAC Financial Functions | YEARFRAC(Start, End[, Basis]) | |
YEARTODATE Time and Date Functions | YEARTODATE(Line item) | |
YEARVALUE Time and Date Functions | YEARVALUE(Line item) | |
YIELD Financial Functions | YIELD(Settlement, Maturity, Rate, Price, Redemption, Frequency [, Basis]) |