Hi,
In my grid I use the aggregate functions to show a total.
However, some grid lines must be ignored. Can I control the aggregate (e.g with sql).
Or, any suggestions on how to this otherwise?
Best answer by Mark Jongeling
View originalHi,
In my grid I use the aggregate functions to show a total.
However, some grid lines must be ignored. Can I control the aggregate (e.g with sql).
Or, any suggestions on how to this otherwise?
Best answer by Mark Jongeling
View originalHi,
This is not possible. The aggregation will happen over all visible rows and uses all values in each row column it is set on.
Alternatively you could add a new expression column that shows a value when it should be used in the aggregation and no value when not, for example:
Value | Expression | |
---|---|---|
3 | 3 | |
5 | 5 | |
-4 | null | |
Total | 4 | 8 |
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.