Rounding attribute value up to closest 100?

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

 

Hi Eva,

 

 

The AttributeRounder works fine, if you write -2 for Decimal Places.

 

 

 

Thomas

or

 

(@round((@Value(Nr_to_R)+100)/100))*100

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!

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.

 

Gio, does the expression always work as your expecting?

 

1400 --> ?

 

1350.0 --> ?

thank you all for the solutions, it's working now!

...ok....that would be (@round((@Value(Nr_to_R)+99)/100))*100

 

 

:)