QGIS Attribute Table – Removing Decimal Part from Float Field

attribute-tabledoublefield-calculatorqgisremove

I have a field called "_mean" and I would like to remove the decimal part of all the values of that field.

I attach two pictures. One an example of my variable ("_mean") in the attribute table and another the type of variable which "_mean" is. I am trying doing something like this Remove decimal points from string field using field calculator but it does not work. My version of QGIS is 3.24.0.

In the example, I would like that my variable _mean takes a values of 710000 instead of 710000.000000000000000

Best Answer

You can use the Field Calculator to create a new field with Precision = 0. Setting your expression to "_mean" will carry through the values to your new field.

Related Solutions

[GIS] Remove decimal points from string field using field calculator

You can do this with a string with the following VBA in the field calculator:

Left([FIELD_NAME], InStr(1,[FIELD_NAME], ".") - 1)

That will remove the decimal and everything after. If you want some number of digits after the decimal, replace the -1 with + like so:

  Left([FIELD_NAME], InStr(1,[FIELD_NAME], ".") + 2)

will give you 2 decimal places. However, this is going to throw errors if some rows have fewer decimal places than you're shortening to. Goldring's answer may be more stable and universal, but if you know your data, you can do it directly in a string field.

[GIS] Decimal number changed to whole number

Decimal number(integer)

Is a whole number.

You want to use:

Decimal number (real)

Also as mentioned by Joseph in the comments make sure you have a precision set. So precision is how many decimal places get saves and width is the overall number if digits stored both before and after the decimal place.

Best Answer

Related Solutions

[GIS] Remove decimal points from string field using field calculator

[GIS] Decimal number changed to whole number

Related Question