Functions

XLReporting supports 280 functions. Most functions are compatible with Microsoft Excel, and adhere to identical syntax and parameters. On top of Excel-compatible functions, XLReporting also provides 100+ special functions that uses 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