Solved

Can I control Grid aggregate functions

  • 1 September 2021
  • 2 replies
  • 36 views

Userlevel 5
Badge +12

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? 

e.g ; Instead of 600,- I want the first grid line to be ignored, and show 500,- 

 

icon

Best answer by Mark Jongeling 1 September 2021, 09:42

View original

2 replies

Userlevel 7
Badge +23

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

 

Userlevel 5
Badge +12

Thanks for the quick fix, as always much appreciated. Too bad it can't be controlled. I will check with what might a nice alternative. 

 

Reply