Round down to nearest 0.5 ft in Point Table

Round down to nearest 0.5 ft in Point Table

Katarzynha
Contributor Contributor
646 Views
3 Replies
Message 1 of 4

Round down to nearest 0.5 ft in Point Table

Katarzynha
Contributor
Contributor

I am wondering if there is any way to round down my elevation values to the nearest 0.5 foot. I am working with the Point data and those elevations are taken from the surface. The values in table (in white) show the original values, and the ones in red is what I am trying to achieve. I will appreciate any help! I have way to many points to do it manually.

 

RoundDown.jpg

0 Likes
Accepted solutions (2)
647 Views
3 Replies
Replies (3)
Message 2 of 4

Jeff_M
Consultant
Consultant
Accepted solution

Create an Expression under the PointLabel styles name Nearest_Half. For the Formula use 

ROUND({Point Elevation}/0.5)*0.5

and have it formatted as an Elevation. Now you can use this expression for the elevation in the table style.

Jeff_M, also a frequent Swamper
EESignature
Message 3 of 4

Jeff_M
Consultant
Consultant
Accepted solution
Oops, you said round down, so replace the ROUND function with FLOOR
Jeff_M, also a frequent Swamper
EESignature
Message 4 of 4

Katarzynha
Contributor
Contributor

Amazing! Works like a charm! Thank you very much!

0 Likes