How to limit a calculated field with “real” to 1 number after the decimal?

Hi Florence,
What you can do is to format the number that comes from your expression by wrapping it into the format-number function. Examples:
- limit a number to 1 decimal digit: format-number(MY_NUMERIC_EXPRESSION, "#.0")
- limit a number to 2 decimal digit: format-number(MY_NUMERIC_EXPRESSION, "#.00")
Note that the format-number expression will truncate your decimal part... if you want to do something a bit more complex, then try to combine it with some other numeric functions, like round, ceiling, floor. All of these functions are core functions of the XPath language, you can find lots of documentation on internet (here for example).
Thanks,
Open Foris Team

Hi Florence,
The expression you wrote is wrong because the function round accepts only one parameter. In theory looks even wrong to me because it will cut the decimal part of the number... What you can do is for example this:
format-number(round(cropland_tree_count * 100 div cropland_area) div 100, "#.00")
In this way the result should be the expected one... Let us know!
Thanks,
Open Foris Team

Hi Florence,
Probably this expression gives an error when one of the operands is null... try to specify this in the Apply when condition:
cropland_tree_count > 0 and cropland_area > 0
Also please don't forget that the format-number function will work only if you use it in a calculated "Text" attribute... otherwise the formatting can result in a invalid number error if used for a "Numeric" attribute. If you just need to limit the decimal digits, maybe using only the round/ceiling/floor functions will be enought...! I hope it's more clear now!
Thanks,
Open Foris Team