Jump to content
  • 0

Suming Lengths in a Worksheet Database



I am trying to create a worksheet that sums the total length of lines in certain classes. Ideally, I would like to do this via a database instead of using spreadsheet mode and a formula.


In the attached worksheet I have set up 3 classes with 3 lines each. I have built databases for each class. I want to summarize the data so that instead of showing each of the 3 lines and their lengths as separate rows, the contents of the database is summarized as a single row (IE row 5.1 would display "Class A" in column A & "30" in column B.


If I try to summarize Column A using the Summarize Items function it summarizes the 3 rows down to a single row which displays "Class A" in column A but only displays "---" in column B. No other combination of the Summarize Items & Sum functions seems to get me what I want.


Am I stuck using formulas or is there a way around this that would allow me to use a database.


Line Lengths Worksheet.vwx

Edited by GlueDT92
Updated to correct file
Link to comment

2 answers to this question

Recommended Posts

  • 0

IN column B, choose the Sum Values Option when you use the Summarize option in column A.


You could actually do this with a single database. Edit the Report (or database) criteria to include Class is rows for Class A, Class, B and Class C.


Put a formula of =C in the column A header. This will give you the name of the class of every object in the drawing. Put the formula of =LENGTH in the column B header.

Go to the pull down menu for column A and click the Summarize button. This will give you one row for every class.

Go to the pull menu for column B and click the Sum Values button. Column B will now add the values for all the hidden subrows.


Write back if you need more help.

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.

Answer this question...

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