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?
Answer
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 replies.
+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"
+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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.