Functions

XLReporting supports 250+ functions. Most functions are 100% compatible with Microsoft Excel, and adhere to identical syntax and parameters. On top of Excel-compatible functions, XLReporting also provides a number of special functions to access the unique functionality in XLReporting. These functions are marked by ❖ XLReporting. You can use functions anywhere in imports, reports, models, and queries.

Select by type:

All Text Date Number Aggregate Filters Lookups Period Queries Math System Financial Conditional Common Special

Or select alphabetically:

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z




Recommended reading:
Back to top | Imports | Reports | Models