vhector Posted May 7, 2007 Share Posted May 7, 2007 (edited) I made a data-symbol, in that symbol I make some data, like sqm for me. When I make a worksheet of it, the data comes in sub-rows. Problem is for SUM, I can't do that in subrows. Only count the subrows itself, and not the data in it. Is there a solution for it? Edited May 7, 2007 by vhector Quote Link to comment
Vectorworks, Inc Employee Robert Anderson Posted May 7, 2007 Vectorworks, Inc Employee Share Posted May 7, 2007 Type the following formula in the database header row: = 'Record Format Name'.'Field name' Where the record and field names are the particular value you wish to return. Then the values will automatically sum in the database header row. You can reference the cell in the database header if you need to display it elsewhere in the worksheet. Quote Link to comment
vhector Posted May 7, 2007 Author Share Posted May 7, 2007 (edited) Well yeah, you get this 1 / Nr. /Nme /sqm 2 / 3 / 3 / 3 2.1 /0.1 /1e / 10 2.2/ 0.2 /2e / 30 2.3 /0.3 /3e /10 But I want this 1/ Nr./ Nme/ sqm 2 / 3 / 3 / 50 2.1 /0.1 /1e /10 2.2/ 0.2 /2e / 30 2.3/ 0.3/ 3e / 10 Edited May 7, 2007 by vhector Quote Link to comment
Vectorworks, Inc Employee Robert Anderson Posted May 7, 2007 Vectorworks, Inc Employee Share Posted May 7, 2007 This is because you have defined your last (rightmost) field as text instead of as a number. Re-define the field type as a number and it will work. Quote Link to comment
vhector Posted May 8, 2007 Author Share Posted May 8, 2007 offcoarse, many thanks. 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.