Monday, October 15, 2012


Expressions can be hard, especially when you want to do hard things. Sometimes you may want to round to the nearest 0.1%, but show two digits. Not sure why one would want to do that, but if you did here’s an example of an expression that will do such a thing.

(ROUND({Pipe Slope}*10))/10

If you want the nearest 0.5% then this expression should work:

(ROUND({Pipe Slope}*2))/2

Happy expressioning.

No comments:


Blog Widget by LinkWithin