gasjar Posted March 29, 2012 Share Posted March 29, 2012 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. Quote Link to comment
Pat Stanford Posted March 29, 2012 Share Posted March 29, 2012 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. Quote Link to comment
gasjar Posted June 6, 2012 Author Share Posted June 6, 2012 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? Quote Link to comment
Pat Stanford Posted June 7, 2012 Share Posted June 7, 2012 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. 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.