willofmaine Posted November 10, 2022 Share Posted November 10, 2022 VW 2022. Elevation Benchmark objects on different design layers with "Elevation Display" set to "Z value relative to reference elevation." On the design layers, they display their heights with respect to World Z=0, as expected and desired (adjusted for the reference elevation). How do I simply report on those actual heights in a Worksheet / Report??? The best I can seem to get is their heights with respect to their design layers (Functions > ZCoordinate). @Pat Stanford, any thoughts? Also, on the design layers, their elevations are displayed in the 12'-8.4" format, but in the worksheet they're displayed in the 12'8 3/8" format, and there seems no way to get them to match... Quote Link to comment
Pat Stanford Posted November 10, 2022 Share Posted November 10, 2022 Try 'Elevation Benchmark2'.'Elev' =CONCAT(INT('Elevation Benchmark2'.'Elev'), '''-', ('Elevation Benchmark2'.'Elev'-INT('Elevation Benchmark2'.'Elev'))*12, '"') The foot unit mark is entered as three single quotes, a dash, and another single quote to end the string. The inch unit mark is a single quote, a double quote, and another single quote to end the string. Very hard to tell without the words. The above formulas do not round or truncate to a single decimal point. If you need that it will take more work. Quote Link to comment
willofmaine Posted November 10, 2022 Author Share Posted November 10, 2022 ='Elevation Benchmark2'.'Elev' just returns 0" for all of them. I copied and pasted your "=CONCAT........" and that just returned 0'-0". Not sure what I'm missing... Quote Link to comment
Pat Stanford Posted November 10, 2022 Share Posted November 10, 2022 No idea. It works in this file. VW2023 Elevation Benchmark to WS.vwx Quote Link to comment
willofmaine Posted November 10, 2022 Author Share Posted November 10, 2022 I think the Elevation Benchmark object is overhauled or even entirely new for VW 2023, so maybe the formulas aren't applicable in 2022? And in 2023 it looks like the units can be set specifically for the Elevation Benchmark (rather than only just using the document units), in which case I'd just make both the Benchmarks and the reports use the same Decimal format. Oh well... probably not worth pursuing at this point with VW 2023 on the horizon. In the meantime, thanks Pat! Quote Link to comment
Pat Stanford Posted November 10, 2022 Share Posted November 10, 2022 Sorry, I missed that it was VW2022. In VW2022 the Elevation Benchmark has a record name of just 'Elevation Benchmark' without the 2 on the end. Here is the list of all of the possible fields. Quote Link to comment
willofmaine Posted November 11, 2022 Author Share Posted November 11, 2022 Thanks. It really doesn't seem like it should be so difficult to simply run a report on the elevation of an elevation benchmark! Oh well; thanks for your help! 1 Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.