Jump to content
SgtPepper

Worksheet - Sum of Database Items (Area Totals)

Recommended Posts

Hey all,

 

Quick worksheet question for the veterans. Is it possible to get a SUM of areas generated from space objects. The SUM function adds together the number of database objects rather than of the information they are providing. I've attached a dropbox link to a jpeg that will explain it better than I can. 

 

https://www.dropbox.com/s/z62v30i61i5965i/Worksheet Screenshot.png?dl=0 

Share this post


Link to post

At a guess you have =('Space'.'11_Area')  in your database header rather than =('Space'.'Area') - this is the difference between 'Space Area' and Space Area Number when you are selecting fields under create report.

 

If you change the header to =('Space'.'Area') it should work - you will have to add the 'sq m' as a trailer to the cell formatting.

Share this post


Link to post

As an explanation, the Space Object contains duplicate field for some items, one storing the data in a TEXT format, the other storing it as a NUMBER. TEXT representations can not have math performed on them (Such as SUM).

 

You can use the script in the following thread to determine the field types for any PIO.

 

 

Share this post


Link to post

Yep.

 

The Space name is =('Space'.'11_NameDisplay')

The Occupancy Org is =('Space'.'11_OccupantDisplay')

The Occupant is =('Space'.'11_Occupancy Type')

 

 

Share this post


Link to post
6 minutes ago, michaelk said:

Yep.

 

The Space name is =('Space'.'11_NameDisplay')

The Occupancy Org is =('Space'.'11_OccupantDisplay')

The Occupant is =('Space'.'11_Occupancy Type')

 

 

Thanks a lot

 

Share this post


Link to post

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×
×
  • Create New...