Dealing with null values in streaming rollup

[RAUNAK AGRAWAL]

Hi,

I am trying to use streaming rollup expression to aggregate the sales
values over week. Here is the query:

curl http://localhost:8983/solr/metrics_data/stream -d 'expr=rollup(
   search(metrics_data, q=id:123, fl="week_no,sales,qty", qt="/export",
sort="week_no desc"),
  over="week",
   sum(sales),
   sum(qty)
)'

But I am getting exception like:

{
"result-set": {
"docs": [{
"EXCEPTION": null,
"EOF": true,
"RESPONSE_TIME": 169
}]
}
}

The reason being some of the documents are having null as sales. One option
is to wrap the search with select expression
with replace(field,null,withValue=0). Is there any other way for rollup to
ignore those docs which has some fields as null?

Thanks in advance