Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of robert.newson@gmail.com
 designates 209.85.215.54 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CADA9kr-Bqoz4CwSAB56M+MvBMOi4VvqbsJ6EGPEVzuN=Yw2RzQ@mail.gmail.com>
References: 
 <CA+VOMAJ=HZn7rdSsC8fes7KkyHsfWxkbAhnhh1xzdQwudATgjQ@mail.gmail.com>
	<CAKiq=tD1TuELtse+bfYVDE8iwEsggFLHhn+T-comK3OAFMMVBA@mail.gmail.com>
	<CADA9kr-Bqoz4CwSAB56M+MvBMOi4VvqbsJ6EGPEVzuN=Yw2RzQ@mail.gmail.com>
Date: Fri, 15 Nov 2013 10:46:13 +0000
Message-ID: 
 <CABvT1DFE+VcybKv4LcE8vF6=WWmMY2AjL54Q_5HG+SV8juSfLA@mail.gmail.com>
Subject: Re: decimal and builtin _sum function
From: Robert Newson <robert.newson@gmail.com>
To: "user@couchdb.apache.org" <user@couchdb.apache.org>,
 Andreas Wenk <andy@nms.de>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

To answer the original question, _sum can only sum numbers, it does
not understand numbers inside strings.

On 15 November 2013 10:27, Andy Wenk <andy@nms.de> wrote:
> sidenote: super cool talk by Bartek Szopka about floating point numbers i=
n
> JavaScript (and other languages) held at JSConf.eu 2013
>
> https://www.youtube.com/watch?v=3DMqHDDtVYJRI
>
>
> On 15 November 2013 11:00, Mike Marino <mmarino@gmail.com> wrote:
>
>> Hi Pedro,
>>
>> On Fri, Nov 15, 2013 at 10:29 AM, Pedro Narciso Garc=EDa Revington
>> <p.revington@gmail.com> wrote:
>> > Hi,
>> >
>> > I want to sum decimals with the builtin _sum function.
>> > My documents look like
>> > {
>> >    "_id": "7a2c5e50dfeb1341d02aa27c7a05f629",
>> >    "_rev": "4-482ff2f6b6e5c2aa079e3e4114d02093",
>> >    "type": "payment",
>> >    "amount": "0.2"
>> > }
>> > I store the numbers as strings because I read this the proper way for
>> > decimals.
>>
>> I would echo Stefan's suggestion in this case since you're dealing
>> with adding "money" numbers.  Otherwise, you have to deal with normal
>> numerical rounding issues when performing operations on floats.
>>
>> >
>> > If I try to sum them with the builtin _sum I get the following error
>> > "builtin _sum function requires map values to be numbers"
>> >
>> > I removed the quotes from the numbers. Now I can sum them but 0.2 + 0.=
1
>> > equals to 2.99999999
>>
>> Was this a typo?  Did you mean 0.2999999 ?
>>
>> Cheers,
>> Mike
>>
>
>
>
> --
> Andy Wenk
> Hamburg - Germany
> RockIt!
>
> http://www.couchdb-buch.de
> http://www.pg-praxisbuch.de
>
> GPG fingerprint: C044 8322 9E12 1483 4FEC 9452 B65D 6BE3 9ED3 9588