Rounding to 2 decimal places using MongoDB aggregation framework

by

There is no $round operator but you can do this in the aggregation framework – doing it in specific order will usually avoid floating point precision issues.

> db.a.save({x:1.23456789})
> db.a.save({x:9.87654321})
> db.a.aggregate([{$project:{ _id:0, 
         y:{$divide:[
              {$subtract:[
                      {$multiply:['$x',100]},
                      {$mod:[{$multiply:['$x',100]}, 1]}
              ]},
              100]}
}}])
{ "y" : 1.23 }
{ "y" : 9.87 }

Given the existing pipeline in the problem, replace:

{$multiply:[{$divide: ['$ActSls', '$PlnSls']},100]}

with

{$divide:[
     {$subtract:[ 
          {$multiply:[
             {$divide: ['$ActSls','$PlnSls']},
             10000
          ]}, 
          {$mod:[
             {$multiply:[{$divide: ['$ActSls','$PlnSls']}, 10000 ]},
             1]}
          ]}, 
     100
]}

With your sample data points this is the result:

{ "ActSls" : 31, "PlnSls" : 51, "ActToPln" : 60.78 }
{ "ActSls" : 41, "PlnSls" : 51, "ActToPln" : 80.39 }
{ "ActSls" : 72, "PlnSls" : 102, "ActToPln" : 70.58 }

More Related Contents:

  1. Does MongoDB’s $in clause guarantee order
  2. $lookup on ObjectId’s in an array
  3. Mongodb sort inner array
  4. Return only matched sub-document elements within a nested array
  5. Converting string to date in mongodb
  6. Check if every element in array matches condition
  7. MongoDB nested lookup with 3 levels
  8. How to aggregate sum in MongoDB to get a total count?
  9. MongoDB : Aggregation framework : Get last dated document per grouping ID
  10. MongoDB Full and Partial Text Search
  11. Matching ObjectId to String for $graphLookup
  12. Mongodb Join on _id field from String to ObjectId
  13. Find duplicate records in MongoDB
  14. $unwind empty array
  15. How to get back the Original document back after aggregation
  16. Mongo sort on a calculated condition
  17. Find all duplicate documents in a MongoDB collection by a key field
  18. MongoDB lookup when foreign field is an array of objects
  19. MongoDB: Calculate dwell time between every status value change
  20. Search on multiple collections in MongoDB
  21. Using stored JavaScript functions in the Aggregation pipeline, MapReduce or runCommand
  22. MongoDB – The argument to $size must be an Array, but was of type: EOO / missing
  23. How to flatten a subdocument into root level in MongoDB?
  24. $skip and $limit in aggregation framework
  25. How to access overall document count during arithmetic aggregation expression
  26. How to deal with the timezone issue when storing dates in utc using mongod?
  27. Mongodb Aggregation Framework | Group over multiple values?
  28. count array occurrences across all documents with mongo
  29. $project in $lookup mongodb
  30. Return actual type of a field in MongoDB

Leave a Comment