Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've added a new column to an attribute table and performed an operation with the field calculator to populate the new column. The result is a column with a percentage. My problem isn't major but I can't seem to limit the number of decimal places so that I just have solid numbers. Right now I have 13 places after the decimal, I would like it to be 0.

share|improve this question

If you create a new field, make it "integer" instead of "real" if you don't want any values after the comma anyway.

Alternatively, use the "toint" function in "conversions".

share|improve this answer
Excellent! Always a great help :) – Chewy Mar 8 '13 at 23:05
@Chewy Please upvote helpful answers and accept answers that solve your problem. – underdark Mar 9 '13 at 8:13

You don't do that in the field calculator, try the properties of that field, there is a button, num or ... That will allow you to set rounding and precision.

share|improve this answer
No you can't change those. – Nathan W Mar 8 '13 at 22:31

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.