Expression That Rounds To Nearest 0.5 Ft

[Anonymous]

C3D 2019.3 Win10

We pay for water main installed to the nearest 1/2 foot. Is there a way I can use an expression/formula in Quantity Takeoff Manager to report pipe lengths to the nearest 1/2 foot? I don't think CEIL, FLOOR, TRUNC or ROUND will do it, but what do I know?

Thanks

[Anonymous]

I think I have it with: ROUND(({Item Length}*2))/2 where Item Length is reported to two decimals.

all thanks to @Alfred.NESWADBA from https://forums.autodesk.com/t5/autocad-forum/round-off-of-the-value-length-of-an-inserted-field/td-p...

Does this look right to you experts? I am not positive I understand how it works. It's hard to check because I have dozens of not hundreds of individual pipe runs and QTO seems to list them randomly. So I am spot checking, and checking the final number, of course.

[cwr-pae]

I'm 99.999999% sure Alfred is right on the math here. I would use it until I noticed the total quantity was not reading to the nearest .5 or .0, at which point I would look for something else being wrong.