//Eva
Question
Rounding attribute value up to closest 100?
Does anyone know how to round an attribute value up to nearest 100 ? For example if I have a value 1367 I want it to be rounded to 1400. And if I have a value of 1305 I also want it to bo rounded to 1400. I tried the AttributRounder, but it seems to only round decimal values.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Hi Eva,
Try this expression with the ExpressionEvaluator.
-----
@ceil(@Value(attribute_name)*0.01)*100
-----
See the help on the ExpressionEvaluator to learn more about @ceil function.
Takashi
I didn't know a negative value can be used for Decimal Places of the AttributeRounder. It's simple and works fine. Thanks for sharing the tips, Thomas!
+15- Contributor
Tho u can use positive or negative rdecimals in the rounder, it has less degrees of freedom.
So if u would want ot round to say 200 or 2, or even better yet 3 (no multiplication by 10 possible now..;) it would be of no use.
(@round((@Value(Nr_to_R)+100)/100))*100 gives full freedom, u can parameterise the values.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.