Hi Vinu, Nice to see you on this mailing list! And thanks for the question.
I think you've probably encountered a bug, because in my opinion the NULL values should be skipped in any kind of aggregation. So let's look into that as a bug, and get a fix out. But in the meanwhile, I can also think of a workaround which would be simply to add a WHERE clause to your query - WHERE columnX IS NOT NULL. Would that work? Kasper 2014-08-08 5:31 GMT+02:00 Vinu Agnihotri <[email protected]>: > Hi Kasper, > > I am from Singapore and have recently started using the META Model. > > I am doing a simple group by query but having a problem when the value is > null or empty in the data of the column where I am trying to group by. > > > Is there any way in which I can set the value as 0 or ignore the value if > it is null? > There are 4 rows and one value of the column is null which I want to > include in my group by. > > My apologies for asking such an easy question > > Thanks > Vinayak >
