SgtPepper Posted November 17, 2016 Share Posted November 17, 2016 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 Quote Link to comment
Tim Harland Posted November 17, 2016 Share Posted November 17, 2016 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. Quote Link to comment
Pat Stanford Posted November 17, 2016 Share Posted November 17, 2016 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. Quote Link to comment
Francisco J. D. Rogers Posted May 12, 2017 Share Posted May 12, 2017 Hello to all: In the Space polygon, I set Space Name, Occupancy Org and Occupant. There are any way to put them in the Worksheet like the Name and Area? Quote Link to comment
michaelk Posted May 12, 2017 Share Posted May 12, 2017 Yep. The Space name is =('Space'.'11_NameDisplay') The Occupancy Org is =('Space'.'11_OccupantDisplay') The Occupant is =('Space'.'11_Occupancy Type') Quote Link to comment
Francisco J. D. Rogers Posted May 12, 2017 Share Posted May 12, 2017 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 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.