Jump to content

window quantity


mattryan

Recommended Posts

Hello All I am sure this has been covered before, all I want to do is add a quantity column to my window schedule and to summarize the windows that are the same and have a total count.

So I have 5 W01 windows, I can het it to summarize so I don't see each W01 listed but I cannot figure out how to have a quantity column which seems like it should be easy.

 

Can anyone help?

 

Thank you very much

Link to comment

Hello Pat thanks for the response.

Sorry I may need a bit more guidance on this, so i create a new column for QTY, do i need to set any parameters for this?

Where does the formula get inserted? I have tried inserting at the header and in the individual cells that I would like to total but its not working.

I'm using Vectorworks 2018 on Mac.

 

Thank you again for your help

 

Link to comment

Sorry for the delay.

 

The Criteria set the objects that are going to return in each database row. It sounds like you have done that part OK and have all the objects you want in a database.

 

The SUMmary option collapses the subrows so that there is a single subrow for each value in the column that is SUMmarried.

 

The =Count formula will go into the Header Row (ie. 3, not 3.1, 3.2, etc.) for the column that you want to show the number of objects in each row.

 

Insert a new column where you want the total and enter the =Count formula into the header row and you should get what you need.

Link to comment

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