Jump to content
Sign in to follow this  
gasjar

This seems like it should be simple

Recommended Posts

Generating a worksheet for Window Daylight and Vent calculations. Summarize the table so all windows that are alike appear as one line item. This ends up summarizes the DLO and VO for the windows which is not what I want to display. I want this schedule to display the DLO and VO for the type of window not the sum of dlo/vo of the windows with that designation. One way I thought about doing this was adding a column that showed the number of windows per line that had that designation and a column that divided the sum of DLO field by the quantity. But I cannot figure out how to get the quantity (count) of the number of symbols with that designation. Ive included screen captures of the table before the sum applied to the first column and after.

Share this post


Link to post

If you are on VW2012 you can just drag a SUM tile to the columns you don't want totaled. Make sure you select a row in the database first.

Before 2012 you were limited to 3 SUM tiles now it is unlimited.

Your idea of dividing by the count was the best previous work around.

Share this post


Link to post

Pat

Another thread answered the question with putting a number 1 in the Header field, beautiful simplicity.

Now I have another question, when creating my own Worksheet I want to only include the records that are toggled "On Schedule" and eliminate the space I use for other purposes like the 1st floor area, etc...

What is the criteria required to do this? do I use the logical IF function on that Field being "True", then show the data of those records?

Share this post


Link to post

You need to edit the database criteria and add an additional criteria for On Schedule.

Add a door or window to a new blank document and create the built in schedule. The criteria for that includes the On Schedule criteria. You will have to show the database headers to be able to edit the criteria.

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
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.

×