Amelia S Posted November 10, 2015 Share Posted November 10, 2015 Can anyone tell me how to get my door schedule to sort like this: list each door type once, no matter how many there are, and the height, width, and thickness show up for one door, like 2'-8" x 8'-0" x 1 3/4". When I list them all individually, these dimensions show as intended. But right now, when I summarize redundant doors, the fields for the doors' dimensions are multiplied by the number of instances of the door. Say there are 3 of those 2'-8" x 8'-0" doors; they show up as 8'-0" x 24'-0". How is this done? Thanks! Quote Link to comment
Pat Stanford Posted November 11, 2015 Share Posted November 11, 2015 The first SUM tile you add will SUMMARIZE the database by that column. Each Additional SUM tile that you add will "UnSum" that column and give you the "average" of all the values that are SUMMARIZED in that row. If they are all identical, you will get the value you are looking for. Quote Link to comment
Amelia S Posted November 11, 2015 Author Share Posted November 11, 2015 Interesting! Thank you, that works perfectly. 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.