# How I convert a number to 3 decimal points?

I’m having a problem where I can’t convert numbers to something like "0.037", given the case where I have 37 as one of these numbers, without this affecting larger numbers like "2015", which in turn manage to become "2.015". I tried approaches like: myNumber = parseFloat(myNumber.toFixed(3)); myNumber = (myNumber / 1000).toFixed(3); i keep having my… Read More How I convert a number to 3 decimal points?

# the ifs aren't working properly most of the time in this code. [java]

import java.io.IOException; import java.util.Scanner; public class Main { public static void main(String[] args) { Scanner s = new Scanner(System.in); double A=0, J=1; int aux=0; for(int i = 0; ; i++){ if(A%1==0.0 && J%1==0.0) { System.out.printf("I=%.0f J=%.0f\n", A, J); } else if(A%1!=0 && J%1==0) { System.out.printf("I=%.1f J=%.0f\n", A, J); } else if(A%1==0 && J%1!=0) { System.out.printf("I=%.0f… Read More the ifs aren't working properly most of the time in this code. [java]

# How to Find the number zero in decimal part where add no value to the number and remove that part

I am using the following code to convert cm to the meter. public static double? ConvertCmToM(double? cm) { return cm.Value * 0.01; } When I input the number 8.8 output giving as 0.08800000000000001m But I want to stop in the index where zero adds no value in the decimal part. In this case I want… Read More How to Find the number zero in decimal part where add no value to the number and remove that part

# MySQL modify column, data trunctation out of range, but when range increased

I Have table with column of decimal(20, 2) unsigned. I am trying modify this column (increase fraction part precision): alter table table_name modify column column_name decimal(20, 18) unsigned; But receiving error: [22001][1264] Data truncation: Out of range value for column ‘amount’ at row 1 And what strange – I don’t have row with such id… Read More MySQL modify column, data trunctation out of range, but when range increased

# How to replace a commas with periods in text for decimal numbers in python

To replace commas with periods in text for decimal numbers in Python, you can use the `replace()` method of the `string` class. Here is an example of how you could do this: This will print the following output: Keep in mind that this will only work if the commas are used as decimal separators. If… Read More How to replace a commas with periods in text for decimal numbers in python

# Show 2 digits before decimal and show 3 digits after decimal point

The number is a single digit or whatever its, I want the value as before 2 digit and after 3 digits in decimal value. Received values: 7, 07, 07.1, 07.10, 17.222, Expected output: 07.000, 07.000, 07.100, 07.100, 17.222 >Solution : function formatNumber(number) { return number.toFixed(3).padStart(6, ‘0’); } Does this do the trick for you ?

# Decimals – I try to use "." gives error in one place I try "," gives in another place

I insert for example 12.45 gives me error here: //Input string was not in a correct format deposit = decimal.Parse(Console.ReadLine()); If I insert 12,45 gives me error here: //Incorrect syntax near ‘,’ var reader = cmd.ExecuteReader(); Here is already after the part where it gives error on top, and the value already works up there,… Read More Decimals – I try to use "." gives error in one place I try "," gives in another place

# Creating python decimal with locale formatted string

I am using the Python decimal module, I’ve set my locale to Germany such that locale.localeconv()["decimal_point"] is ",". When I try creating a decimal like decimal.Decimal("1,23"), I get a decimal conversion syntax error. When I do decimal.Decimal("1.23"), it works. Does the Python decimal not respect locale settings when creating decimal from string? >Solution : No,… Read More Creating python decimal with locale formatted string

# Inherit class Decimal, and add another input argument in the constructor

A minimal example to reproduce my problem: from decimal import Decimal class MyDecimal(Decimal): def __init__(self, value, dummy): super().__init__(value) print(dummy) x = MyDecimal(5, ‘test’) Throws: TypeError: optional argument must be a context A similar issue is described in this question, but the answer suggests that this is a bug which was fixed on Python 3.3, and… Read More Inherit class Decimal, and add another input argument in the constructor

# Java Addition throws wrong Decimal Result

I have an error in Java for an Android app where two doubles have to be added together. The third addition then results in a long decimal number, e.g. 137.239999999. How can I bypass this error? public void calculateOnAction() { editString(); sumscans ++; sumgrosweight = sumgrosweight + grosweight; sumnetweight = sumnetweight + netweight; String sumgroschar… Read More Java Addition throws wrong Decimal Result