This is a column box test
| Excel | XLeratorDB + SQL Server | ||||
|---|---|---|---|---|---|
| Function | Total | Total | Match | New | Native |
| Financial | 52 | 54 | 51 | 3 | 0 |
| Statistics | 82 | 84 | 64 | 10 | 12 |
| Math | 59 | 51 | 27 | 4 | 23 |
| Engineering | 39 | 42 | 38 | 4 | 0 |
| Conversions* | 49 | 77 | 0 | 77 | 0 |
| Strings | 26 | 58 | 11 | 24 | 23 |
| *Microsoft includes these functions within Engineering using variable input configurations | |||||
| Financial | Statistical | Engineering |
| Math and trigonometry | Date and time | Lookup and reference |
| Information | Logical | Text and data |
| Add-in and automation functions | Cube | Database and list management |
-->
XLeratorDB uses three kinds of functions to perform analytic operations: scalar, aggregate, and a hybrid form which the Westclintech calls “range queries.” Scalar functions [Wikilink] take a single value, perform an operation and returns a single value[i]. An example of this type of function is LOG, which returns the logarithm of a number to a specified base[ii]. Aggregate functions [Wikilink] operate on a collection of values but return a single, summarizing value. An example of this type of function is AVG, which returns the average of values in a specified group[iii]. [i] Also see: http://office.microsoft.com/en-us/excel/HP100698281033.aspx
[ii] Excel definition
[iii] SQL Server definition