Zheng, You may want to check https://issues.apache.org/jira/browse/SOLR-7452. I don't know whether they are absolutely related but I am sure I have seen complaints and enquiries regarding not precise statistics with JSON Facets.
Amrit Sarkar Search Engineer Lucidworks, Inc. 415-589-9269 www.lucidworks.com Twitter http://twitter.com/lucidworks LinkedIn: https://www.linkedin.com/in/sarkaramrit2 On Tue, Jul 25, 2017 at 6:27 PM, Zheng Lin Edwin Yeo <edwinye...@gmail.com> wrote: > This is the way which I put my JSON facet. > > totalAmount:"sum(sum(amount1_d,amount2_d))" > > amount1_d: 69446961.2 > amount2_d: 0 > > Result I get: 69446959.27 > > > Regards, > Edwin > > > On 25 July 2017 at 20:44, Zheng Lin Edwin Yeo <edwinye...@gmail.com> > wrote: > > > Hi, > > > > I'm trying to do a sum of two double fields in JSON Facet. One of the > > field has a value of 69446961.2, while the other is 0. However, when I > get > > the result, I'm getting a value of 69446959.27. This is 1.93 lesser than > > the original value. > > > > What could be the reason? > > > > I'm using Solr 6.5.1. > > > > Regards, > > Edwin > > >
