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?
Solved
Can I control Grid aggregate functions
+13Best answer by Mark Jongeling
Hi,
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 |
This topic has been closed for comments
+23Hi,
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 |
"Wake me up before you low-code"
1 person likes this
+13Thanks for the quick fix, as always much appreciated. Too bad it can't be controlled. I will check with what might a nice alternative.
1 person likes this
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.