Re: Sum of double fields in JSON Facet

[Zheng Lin Edwin Yeo <ed...@gmail.com>]

Hi Amrit,

Thanks for your reply.
So does this means that we can consider this as a bug in JSON Facets?

Regards,
Edwin


On 26 July 2017 at 01:57, Amrit Sarkar <sa...@gmail.com> wrote:

> 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 <edwinyeozl@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 <ed...@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
> > >
> >
>