We're trying to use Space objects to generate building square footages for cost estimating. However, when we report on the Gross or Net areas of the Space objects, it seems we can't get totals in the Worksheet database header row; all that displays is the number of Space objects being reported on. If we use the " =AREA" function, we get areas for the Space objects, and the total area for all Space objects displays in the header row as expected. But the " =AREA" function appears to just return the Net area; we want to be able to report on the Gross area as well. So... how do we do that?... @Pat Stanford , I'm guessing you might know the answer?...
Also, does the Space object include a field for cost per square foot? The User-Defined Fields just appear to be Text fields, so not very useful for compiling numeric totals...
Lastly, how does one control the number of decimal places of the areas displayed for a Space object's Gross & Net Square footage? They seem to vary from 0 to 3 decimal places, with no way to fix them all at 2 decimal places (the varying number of decimal places make the area numbers difficult to quickly read & understand...)
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.
Question
willofmaine
We're trying to use Space objects to generate building square footages for cost estimating. However, when we report on the Gross or Net areas of the Space objects, it seems we can't get totals in the Worksheet database header row; all that displays is the number of Space objects being reported on. If we use the " =AREA" function, we get areas for the Space objects, and the total area for all Space objects displays in the header row as expected. But the " =AREA" function appears to just return the Net area; we want to be able to report on the Gross area as well. So... how do we do that?... @Pat Stanford , I'm guessing you might know the answer?...
Also, does the Space object include a field for cost per square foot? The User-Defined Fields just appear to be Text fields, so not very useful for compiling numeric totals...
Lastly, how does one control the number of decimal places of the areas displayed for a Space object's Gross & Net Square footage? They seem to vary from 0 to 3 decimal places, with no way to fix them all at 2 decimal places (the varying number of decimal places make the area numbers difficult to quickly read & understand...)
Thanks!
Link to comment
5 answers to this question
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.