SimonBarrington Posted May 10, 2021 Share Posted May 10, 2021 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 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. What am I doing wrong? Quote Link to comment
Tom W. Posted May 10, 2021 Share Posted May 10, 2021 Looks like you need to Sum columns A + B to add up all the quantities into single totals Quote Link to comment
SimonBarrington Posted May 10, 2021 Author Share Posted May 10, 2021 Thanks Tom... I know it had to be something silly! Quote Link to comment
Pat Stanford Posted May 10, 2021 Share Posted May 10, 2021 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. 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.