stefano777777 Posted November 10, 2014 Share Posted November 10, 2014 Is there a way to show the record field of an object contained into a listed symbol ? I have a schedule that lists symbols in a given class. Each symbol contains one Space. I would like to have a column that shows the area of the contained space for that symbol. What would be the formula for such record field? Many Thanks S Quote Link to comment
Pat Stanford Posted November 10, 2014 Share Posted November 10, 2014 Is the space only a small portion of the symbol? Do you have other poly's in the symbol. When I did a simple test using a single space, i could use =AREA() on the symbol and get the area of the space back. If I added another poly into the symbol I then get the total area of the space and the poly. Can you attach a file with an example of one of your symbols? Are there going to be instances of the symbol containing a space that you don't want the area for? We can probably come up with a work around, but I don't think there is a way to directly do what you are looking for. Quote Link to comment
stefano777777 Posted November 10, 2014 Author Share Posted November 10, 2014 Thanks Pat, I did no realise I could take the shortcut It works! For the moment that's all I need. I guess I can further refine the polygon/spaces selection using the class. Many Thanks Quote Link to comment
stefano777777 Posted November 11, 2014 Author Share Posted November 11, 2014 (edited) Is there a way to isolate the area by class?I thought I could get areas for a specific class with =AREA(C='ClassName') but this returns a Boolean. I also tried =IF((C='ClassName'), '', AREA) this returns the sum of the areas regardless of the class. My symbols contains a Space, a few walls and a bathroom symbol which contains additional polygons that get summed with the space in the area calculation. If I could isolate the areas by class I could add more polygons and get areas for different purpose. Otherwise I could just do with the space area only avoiding the bathroom area being summed. Any idea/workaround? Edited November 11, 2014 by stefano777777 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.