MongoDB issue reading value with type double [duplicate]

Multi tool use
Multi tool use









0















This question already has an answer here:



  • How to use decimal type in MongoDB

    2 answers



  • Is floating point math broken?

    28 answers



In mongo I have amount stored as 4.77 with type double.



enter image description here



I am using mongo's C# driver to read the Bson document



 var collection = _mongoDatabase.GetCollection<BsonDocument>("mycollection");
 var filter = Builders<BsonDocument>.Filter.Eq("_id", id);
 await collection.Find(filter)
 .ForEachAsync(document => 
 
 var val = document.GetValue("amount");
 );


However, it reads the value as 4.7699999999999996



enter image description here






mongodb mongodb-query







share|improve this question













marked as duplicate by Neil Lunn mongodb
Users with the  mongodb badge can single-handedly close mongodb questions as duplicates and reopen them as needed.

StackExchange.ready(function()
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function()
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function()
$hover.showInfoMessage('',
messageElement: $msg.clone().show(),
transient: false,
position: my: 'bottom left', at: 'top center', offsetTop: -7 ,
dismissable: false,
relativeToBody: true
);
,
function()
StackExchange.helpers.removeMessages();

);
);
);
 Nov 12 '18 at 23:40


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.














  • That's what actually is stored inside the computer. You can't store all decimal float numbers in binary format. Modern computers have approximately 10^-16 accuracy for 8byte (double) type so what you are getting is expected behaviour. The reason you can see the number 4.77 correctly on the GUI database explorer is because of rounding when the number is displayed.
    – itsundefined
    Nov 12 '18 at 23:34















0















This question already has an answer here:



  • How to use decimal type in MongoDB

    2 answers



  • Is floating point math broken?

    28 answers



In mongo I have amount stored as 4.77 with type double.



enter image description here



I am using mongo's C# driver to read the Bson document



 var collection = _mongoDatabase.GetCollection<BsonDocument>("mycollection");
 var filter = Builders<BsonDocument>.Filter.Eq("_id", id);
 await collection.Find(filter)
 .ForEachAsync(document => 
 
 var val = document.GetValue("amount");
 );


However, it reads the value as 4.7699999999999996



enter image description here






mongodb mongodb-query







share|improve this question













marked as duplicate by Neil Lunn mongodb
Users with the  mongodb badge can single-handedly close mongodb questions as duplicates and reopen them as needed.

StackExchange.ready(function()
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function()
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function()
$hover.showInfoMessage('',
messageElement: $msg.clone().show(),
transient: false,
position: my: 'bottom left', at: 'top center', offsetTop: -7 ,
dismissable: false,
relativeToBody: true
);
,
function()
StackExchange.helpers.removeMessages();

);
);
);
 Nov 12 '18 at 23:40


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.














  • That's what actually is stored inside the computer. You can't store all decimal float numbers in binary format. Modern computers have approximately 10^-16 accuracy for 8byte (double) type so what you are getting is expected behaviour. The reason you can see the number 4.77 correctly on the GUI database explorer is because of rounding when the number is displayed.
    – itsundefined
    Nov 12 '18 at 23:34













0












0








0








This question already has an answer here:



  • How to use decimal type in MongoDB

    2 answers



  • Is floating point math broken?

    28 answers



In mongo I have amount stored as 4.77 with type double.



enter image description here



I am using mongo's C# driver to read the Bson document



 var collection = _mongoDatabase.GetCollection<BsonDocument>("mycollection");
 var filter = Builders<BsonDocument>.Filter.Eq("_id", id);
 await collection.Find(filter)
 .ForEachAsync(document => 
 
 var val = document.GetValue("amount");
 );


However, it reads the value as 4.7699999999999996



enter image description here






mongodb mongodb-query







share|improve this question














This question already has an answer here:



  • How to use decimal type in MongoDB

    2 answers



  • Is floating point math broken?

    28 answers



In mongo I have amount stored as 4.77 with type double.



enter image description here



I am using mongo's C# driver to read the Bson document



 var collection = _mongoDatabase.GetCollection<BsonDocument>("mycollection");
 var filter = Builders<BsonDocument>.Filter.Eq("_id", id);
 await collection.Find(filter)
 .ForEachAsync(document => 
 
 var val = document.GetValue("amount");
 );


However, it reads the value as 4.7699999999999996



enter image description here





This question already has an answer here:



  • How to use decimal type in MongoDB

    2 answers



  • Is floating point math broken?

    28 answers






mongodb mongodb-query




mongodb mongodb-query






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Nov 12 '18 at 23:28









LP13

4,6151060132




4,6151060132




marked as duplicate by Neil Lunn mongodb
Users with the  mongodb badge can single-handedly close mongodb questions as duplicates and reopen them as needed.

StackExchange.ready(function()
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function()
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function()
$hover.showInfoMessage('',
messageElement: $msg.clone().show(),
transient: false,
position: my: 'bottom left', at: 'top center', offsetTop: -7 ,
dismissable: false,
relativeToBody: true
);
,
function()
StackExchange.helpers.removeMessages();

);
);
);
 Nov 12 '18 at 23:40


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.






marked as duplicate by Neil Lunn mongodb
Users with the  mongodb badge can single-handedly close mongodb questions as duplicates and reopen them as needed.

StackExchange.ready(function()
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function()
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function()
$hover.showInfoMessage('',
messageElement: $msg.clone().show(),
transient: false,
position: my: 'bottom left', at: 'top center', offsetTop: -7 ,
dismissable: false,
relativeToBody: true
);
,
function()
StackExchange.helpers.removeMessages();

);
);
);
 Nov 12 '18 at 23:40


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.













  • That's what actually is stored inside the computer. You can't store all decimal float numbers in binary format. Modern computers have approximately 10^-16 accuracy for 8byte (double) type so what you are getting is expected behaviour. The reason you can see the number 4.77 correctly on the GUI database explorer is because of rounding when the number is displayed.
    – itsundefined
    Nov 12 '18 at 23:34
















  • That's what actually is stored inside the computer. You can't store all decimal float numbers in binary format. Modern computers have approximately 10^-16 accuracy for 8byte (double) type so what you are getting is expected behaviour. The reason you can see the number 4.77 correctly on the GUI database explorer is because of rounding when the number is displayed.
    – itsundefined
    Nov 12 '18 at 23:34















That's what actually is stored inside the computer. You can't store all decimal float numbers in binary format. Modern computers have approximately 10^-16 accuracy for 8byte (double) type so what you are getting is expected behaviour. The reason you can see the number 4.77 correctly on the GUI database explorer is because of rounding when the number is displayed.
– itsundefined
Nov 12 '18 at 23:34




That's what actually is stored inside the computer. You can't store all decimal float numbers in binary format. Modern computers have approximately 10^-16 accuracy for 8byte (double) type so what you are getting is expected behaviour. The reason you can see the number 4.77 correctly on the GUI database explorer is because of rounding when the number is displayed.
– itsundefined
Nov 12 '18 at 23:34












0






active

oldest

votes

















0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes

qW,nJ6S1q8YPmR9s JM3KNa4
-
IJaeHmcR5 ILXE,Yu6E

Popular posts from this blog

Top Tejano songwriter Luis Silva dead of heart attack at 64

Image
Ramiro Burr's New Blog - to go back: www.ramiroburr.com From Latin rock to reggaeton, boleros to blues,Tex-Mex to Tejano, conjunto to corridos and beyond, Ramiro Burr has it covered. If you have a new CD release, a trivia question or are looking for tour info, post a message here or e-mail Ramiro directly at: musicreporter@gmail.com Top Tejano songwriter Luis Silva dead of heart attack at 64 By Ramiro Burr on October 23, 2008 8:40 AM | Permalink | Comments (12) | TrackBacks (0) UPDATE: Luis Silva Funeral Service details released Visitation 4-9 p.m. Saturday, Rosary service 6 p.m. Saturday at Porter Loring, 1101 McCullough Ave Funeral Service 10:30 a.m. Monday St. Anthony De Padua Catholic Church, Burial Service at Chapel Hills, 7735 Gibbs Sprawl Road. Porter Loring (210) 227-8221 Related New Flash: Irma Laura Lopez: long time record promoter killed in accident NewsFlash: 9:02 a.m. (New comments below) Luis Silva , one of the most well-known ...
Read more

Can't figure out why I get Error loading static resource from app.xaml

Image
1 I having trouble getting my ResourceDictionary.MergedDictionaries to load from app.xaml. My WPF app has a static class with a Main defined and startup object set to it. Within Main I created an instance of App and run it. The override OnStartup fires and the mainwindow.cs InitializeComponent gives the error "Message "Cannot find resource named 'MaterialDesignFloatingActionMiniAccentButton'. If I put the resources in the mainwindow.xaml everything is fine, but I wanted them to load at the app level so I they are not in each page. Any help appreciated. public partial class App protected override void OnStartup(StartupEventArgs e) base.OnStartup(e); var app = new MainWindow(); var context = new MainWindowViewModel(); app.DataContext = context; app.Show(); from the Main.. var app = new App(); app.Run(); app.xaml.. <Application x:Class="GS.Server.App" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:...
Read more

How to fill missing numeric if any value in a subset is missing, all other columns with the same subset are missing

Image
up vote 2 down vote favorite There is a clear pattern that show for two separate subsets (set of columns); If one value is missing in a column, values of other columns in the same subset are missing for any row. Here is a visualization of missing data My tries up until now, I used ycimpute library to learn from other values, and applied Iterforest. I noted, score of Logistic regression is so weak (0.6) and thought Iterforest might not learn enough or anyway, except from outer subset which might not be enough? for example the subset with 11 columns might learn from the other columns but not from within it's members, and the same goes for the subset with four columns. This bar plot show better quantity of missings So of course, dealing with missings is better than dropping rows because It would affect my prediction which does contain the same missings quantity relatively. Any better way to deal with these ? [EDIT] The nullity pattern is confirmed: machine-learning cor...
Read more