Jump to content

Worksheet Summary Issue


Recommended Posts

I have a worksheet in a document to count up fencing requirements for a festival site.

I have done a line type for each type of fencing, and created a record so I can easily give the lines a name to relate to the area

Column A gives me the length of each line, rounded up to the nearest metre. Column B works out the number of Panels, and Column C shows the areas (which is achieved by going the information from the record. This is shown in the first image

623545289_Screenshot2021-05-10at13_28_46.thumb.png.94491bf6368b65a061c657a13593b712.png

 

When I try to Summarize the area's in that column so I don't have so many rows that essentially repeat the same area name, I lose a load of information as shown in the second image.

 

408754523_Screenshot2021-05-10at13_30_01.thumb.png.36be802d51b87a98b093343dc5994ac6.png

 

What am I doing wrong?

 

 

Link to comment

When you SUMmarize multiple sub-rows in a database and they have different values you get the --- to indicate they are not all the same.

 

As Tom W. said, you want to click in the column header (if you don't see the header row [i.e. 3, not 3.1, 3.2, etc.] go to the worksheet View menu and make sure there is a check next to Database Headers) and make sure the Sum Values box is checked. When it is, the SUMmarized row will show the total value of all the SUMmarized rows.

 

Be careful trying to do math on SUMmarized rows. While we would often like to do the math on the SUM, VW actually does the math on the individual sub-rows and then SUM the result of the calculations.

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