bcd Posted April 24, 2017 Share Posted April 24, 2017 (edited) =(('Property Line'.'Area')) returns a non-numeric string. Eg. 31106 sq ft I want use the numeric value to calculate allowable Lot Coverage as prescribed by the zoning How can I extract the area as a number? Edited April 24, 2017 by bcd Quote Link to comment
Jim Smith Posted April 24, 2017 Share Posted April 24, 2017 I would have a couple of columns Column A = Area result (e.g. 31106 sq ft) Column B = The percentage of allowable coverage (e.g. 50% or 0.50) Column C = Allowable Building Envelope (AxB=C) Quote Link to comment
Pat Stanford Posted April 24, 2017 Share Posted April 24, 2017 In this case, the Area is not stored in the Parameter Record as anything but text. BUT, it appears that you can use the =Area function to get the data you need. I only tried this in a database row, but in my test file ='Property Line'.'Area' returned 915.872 sq ft =Area returned 915.872 Sometimes the simple solutions are hardest to see. I created a wish list item for this. Please vote up if you think it is worthwhile. 1 Quote Link to comment
bcd Posted April 24, 2017 Author Share Posted April 24, 2017 Well I'll be.. Thanks Pat. Voting now. Quote Link to comment
Jim Smith Posted April 24, 2017 Share Posted April 24, 2017 - we always use a polygon to represent the lot area & it returns an area on the worksheet Quote Link to comment
bcd Posted April 24, 2017 Author Share Posted April 24, 2017 (edited) 1 hour ago, Jim Smith said: I would have a couple of columns Yes, this is the intention. 30% Roofed Building 20% Other 50% Landscaping =Area works well. Edited April 24, 2017 by bcd 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.