Supported Excel functions
The following is a table of supported Microsoft Excel functions taken from the latest Dashboard Design User Guide, at the time of writing:
ABS |
ACOS |
ACOSH |
AND |
ASIN |
ASINH |
ASSIGN |
ATAN |
ATAN2 |
ATANH |
AVEDEV |
AVERAGE |
AVERAGEA |
BETADIST |
CEILING |
CHOOSE |
COMBIN |
CONCATENATE |
COS |
COSH |
COUNT |
COUNTA |
COUNTIF |
DATE |
DATEVALUE |
DAVERAGE |
DAY |
DAYS360 |
DB |
DCOUNT |
DCOUNTA |
DDB |
DEGREES |
DEVSQ |
DGET |
DIVIDE |
DMAX |
DMIN |
DOLLAR |
DPRODUCT |
DSTDEV |
DSSTDEVP |
DSUM |
DVAR |
DVARP |
EDATE |
EOMONTH |
EVEN |
EXACT |
EXP |
EXPONDIST |
FACT |
FALSE |
FIND |
FISHER |
FISHERINV |
FIXED |
FLOOR |
FORECAST |
FV |
GE |
GEOMEAN |
GT |
HARMEAN |
HLOOKUP |
HOUR |
IF |
INDEX |
INT |
INTERCEPT |
IPMT |
IRR |
ISBLANK |
ISNA |
ISNUMBER |
KURT |
LARGE |
LE |
LEFT |
LEN |
LN |
Get SAP BusinessObjects Dashboards 4.0 Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.