Simple To Use Expression Language
Below are some common examples:
| Expression | Description |
|---|---|
| COUNT(Orders.ID) | Count Orders within the users current filters |
| COUNT(Orders.ID, WHERE(Sales.Year, 2021, 2022)) | Count Orders within the users current filters and where Year = 2021 or 2022 |
| SUM(Orders.Price, WHERE(Sales.Year, Year(Today())),WHERE(Product.Name, "Apples")) | Sum Order Price within the users current filters and where year = the current year and Product.Name = "Apples" |
| COUNT(Orders.ID, WHERE(Sales.Year, 2022)) / COUNT(Orders.ID, ClearAll()) | Calculate the percent of orders for the year 2022 |