Search code examples
javascriptlinq.js

Linq js group by Sum appending string instead of adding

I am using linq.js "//cdnjs.cloudflare.com/ajax/libs/linq.js/2.2.0.2/linq.min.js"

The objective is to get "sum" of a field using group by clause. The code is working fine but "quantity" is considered as a string and appending numbers. If I use g.Sum(parseInt("$.quantity")) or parseFloat I am getting error b is not a function. What am I missing?

  • If I want set some initial value to quantity, how can I?

     aggregatedData = Enumerable.From(someData)
     .GroupBy("$.id", null,
         function (key, g) {
             return {
                 stock: key,
                 quantity: g.Sum("$.quantity"),
                 avgprice: g.Average("$.average_price")
             }
         })
     .ToArray();
Solution

  • I figured it out. g.Sum(function (s) { return parseFloat(s.quantity | 0); })