Sum, Average, Min or Max for nullable fields

[TeeJT]

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

[paramvir]

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