ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: TeeJT on June 02, 2017, 12:43:59 pm

Title: Sum, Average, Min or Max for nullable fields
Post by: TeeJT on June 02, 2017, 12:43:59 pm

Is it possible for nullable fields linked to a column that the null values can be treated as 0 instead of undefined as in the example attached

Title: Re: Sum, Average, Min or Max for nullable fields
Post by: paramvir on June 02, 2017, 02:47:30 pm

For that you can write your own function pq.aggregate.max which treats null values as 0. It would override the inbuilt function.