Some functions have differences in functionality, or are not available, in Polaris.
Title | Description | Category |
---|---|---|
ABS | Numeric Functions | |
ADDMONTHS | Time and Date Functions | |
ADDYEARS | Time and Date Functions | |
AGENTS | Call Center Planning Functions | |
AGENTSB | Call Center Planning Functions | |
ALL | Aggregation Functions | |
ANSWERTIME | Call Center Planning Functions | |
ANY | Aggregation Functions | |
ARRIVALRATE | Call Center Planning Functions | |
AVERAGE | Aggregation Functions | |
AVGDURATION | Call Center Planning Functions | |
AVGWAIT | Call Center Planning Functions | |
CODE | Miscellaneous Functions | |
COLLECT | Miscellaneous Functions | |
COMPARE | Logical Functions | |
COUPDAYBS | Financial Functions | |
COUPDAYS | Financial Functions | |
COUPDAYSNC | Financial Functions | |
COUPNCD | Financial Functions | |
COUPNUM | Financial Functions | |
COUPPCD | Financial Functions | |
CUMIPMT | Financial Functions | |
CUMPRINC | Financial Functions | |
CUMULATE | Time and Date Functions | |
CURRENTPERIODEND | Time and Date Functions | |
CURRENTPERIODSTART | Time and Date Functions | |
CURRENTVERSION | Miscellaneous Functions | |
DATE | Time and Date Functions | |
DAY | Time and Date Functions | |
DAYS | Time and Date Functions | |
DAYSINMONTH | Time and Date Functions | |
DAYSINYEAR | Time and Date Functions | |
DECUMULATE | Time and Date Functions | |
DIVIDE | Numeric Functions | |
DURATION | Financial Functions | |
END | Time and Date Functions | |
ERLANGB | Call Center Planning Functions | |
ERLANGC | Call Center Planning Functions | |
EXP | Numeric Functions | |
FIND | Text Functions | |
FINDITEM | Miscellaneous Functions | |
FIRSTNONBLANK | Aggregation Functions | |
FIRSTNONZERO | Numeric Functions | |
FV | Financial Functions | |
HALFYEARTODATE | Time and Date Functions | |
HALFYEARVALUE | Time and Date Functions | |
IF THEN ELSE | Logical Functions | |
INPERIOD | Time and Date Functions | |
IPMT | Financial Functions | |
IRR | Financial Functions | |
ISACTUALVERSION | Logical Functions | |
ISANCESTOR | Logical Functions | |
ISBLANK | Logical Functions | |
ISCURRENTVERSION | Logical Functions | |
ISFIRSTOCCURRENCE | Logical Functions | |
ISNOTBLANK | Logical Functions | |
ITEM | Miscellaneous Functions | |
LAG | Time and Date Functions | |
LASTNONBLANK | Aggregation Functions | |
LEAD | Time and Date Functions | |
LEFT | Text Functions | |
LENGTH | Text Functions | |
LN | Numeric Functions | |
LOG | Numeric Functions | |
LOOKUP | Logical Functions | |
LOWER | Text Functions | |
MAILTO | Text Functions | |
MAKELINK | Text Functions | |
MAX | Aggregation Functions | |
MAX | Numeric Functions | |
MDURATION | Financial Functions | |
MID | Text Functions | |
MIN | Aggregation Functions | |
MIN | Numeric Functions | |
MOD | Numeric Functions | |
MONTH | Time and Date Functions | |
MONTHTODATE | Time and Date Functions | |
MONTHVALUE | Time and Date Functions | |
MOVINGSUM | Time and Date Functions | |
MROUND | Numeric Functions | |
NAME | Text Functions | |
NEXT | Time and Date Functions | |
NEXTVERSION | Miscellaneous Functions | |
NPER | Financial Functions | |
NPV | Financial Functions | |
OFFSET | Time and Date Functions | |
PARENT | Miscellaneous Functions | |
PERIOD | Time and Date Functions | |
PMT | Financial Functions | |
POST | Time and Date Functions | |
POWER | Numeric Functions | |
PPMT | Financial Functions | |
PREVIOUS | Time and Date Functions | |
PREVIOUSVERSION | Miscellaneous Functions | |
PRICE | Financial Functions | |
PROFILE | Time and Date Functions | |
PV | Financial Functions | |
QUARTERTODATE | Time and Date Functions | |
QUARTERVALUE | Time and Date Functions | |
RANK | Miscellaneous Functions | |
RANKCUMULATE | Miscellaneous Functions | |
RATE | Financial Functions | |
RIGHT | Text Functions | |
ROUND | Numeric Functions | |
SELECT | Logical Functions | |
SIGN | Numeric Functions | |
SLA | Call Center Planning Functions | |
SPREAD | Time and Date Functions | |
SQRT | Numeric Functions | |
START | Time and Date Functions | |
SUBSTITUTE | Text Functions | |
SUM | Aggregation Functions | |
TEXT | Text Functions | |
TEXTLIST | Aggregation Functions | |
TEXTLIST | Text Functions | |
TIMESUM | Time and Date Functions | |
TRIM | Text Functions | |
UPPER | Text Functions | |
VALUE | Miscellaneous Functions | |
WEEKDAY | Time and Date Functions | |
WEEKTODATE | Time and Date Functions | |
WEEKVALUE | Time and Date Functions | |
YEAR | Time and Date Functions | |
YEARFRAC | Financial Functions | |
YEARTODATE | Time and Date Functions | |
YEARVALUE | Time and Date Functions | |
YIELD | Financial Functions |