Skip to main content

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,- 

 

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

 

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


Terms & ConditionsCookie settings