Jump to content

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 

Link to comment

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.

Link to comment
  • 5 months later...

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.

×
×
  • Create New...