SQL grid, column totals Min, Max, and Count does not work for some data types

[Claus Pedersen]

I have a table with some VARCHAR2 columns. The column total functions Min and Max does not work for character strings. it will always show 0 (zero).
Min of A,B,C is A and Max of X,Y,Z is Z, so it can be calculated meaningful.

Also Min does not work correctly for number columns. I have four rows with values
1
2
3
4

I use the Min function. It shows 1. This is OK

Now I change first row to 2. Min is still 1, should be 2.
Now I change first row to NULL. Min is now -1 ?
I change first row back into 1
I re-apply Min, it shows 1, OK
I Change fourth row from 4 into 3. Min is now -1 ??
Rows back to 1,2,3,4, apply Min.
I change all rows to 1. Min is now -3 ???

Also the Count method does not seem to be updated when data is modified (from NULL to a value and back to NULL)

 

[Marco Kalter]

We'll enhance this.

 

[Claus Pedersen]

Thanks