Jump to content
Sign in to follow this  
aqualiscious

Door/Window Summary multiplies all attributes by the COUNT

Recommended Posts

Hello,

I am trying to use the SUM comment icon in a door/window schedule to summarize the total number of doors/windows of each particular size. I can get this part to work easily enough.

The problem I have is to do with the SUM (summary) command multiplies all the individual door/window attributes by my count. In other words, instead of displaying 10 doors at 3'0x7'0 each, the spreadsheet displays 10 doors totalling 30'x70'... Please see attached screen capture.

Any ideas?

I've tried altering the formula in the door.width cell, dividing it by the cell containing the count but the result is some strange number, much smaller than it should be...

??

Edited by aqualiscious

Share this post


Link to post

Try adding a SUM icon to both your Width and Height columns, as well as to the door sizes column. I think this will resolve your issue.

Doing this is probably very logical mathematically (I've yet to work through it...), but intuitive it is not.

Unfortunately, you can only use the SUM icon for three columns (unless you're using VW 2012, in which case I think this may be unlimited) so a lot of your other columns, such as door thickness and jamb depth, will remain problematic....

HTH

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.

Sign in to follow this  

 

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...