Overview
An expression is a combination of one or more values, operators and SQL functions that evaluate to be filled
Remarks
Formula specifies the method of evaluation of row values. Formula enumeration can be one of following valuesa value. You can also use them to query the database for a specific set of data. Expressions can be used on forms with Query control and in scripting with $Database methods.
Remarks
Expressions can consist of multiple SQL functions. The following functions are available;
| Value | Description | None | No aggregation is applied. All values in rows.|
|---|---|---|---|
| Count | Count of row values. | ||
| CountDistinct | Count of distinct values in rows. | ||
| Sum | Sum of row values. Valid for numeric type columns. | ||
| SumDistinct | Sum of distinct values in rows. Valid for numeric type columns. | ||
| Avg | Average of row values. Valid for numeric type columns. | ||
| AvgDistinct | Average of distinct values in rows. Valid for numeric type columns. | ||
| Min | Minimum value in rows. | ||
| Max | Maximum value in row values. | ||
| StdDev | Standard deviation of row values. | ||
| DateDiff | Difference between two date values. Valid for date and datetime type columns. | ||
| DatePart | Crops out the specified part of date values and gives the kept part as number value. Valid for date and datetime type columns. | ||
| DateTrunc | Truncates date values except the specified date part and gives a date value. Valid for date and datetime type columns. |
...
| . |