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 |