gester Posted October 29, 2013 Share Posted October 29, 2013 hi guys, i have troubles with data retrieval from a spaces' report. in order to calculate the cost of the space areas i've utilized one of the user defined fields in the space object ('additional data' tab). the original field is called 'additional info 01', i've renamed it to 'cost per sq m' and hard coded a monetary value as its data. then i've created a spaces' report where i included this additional field. so far so good, the hand-inserted values appear in the worksheet (attachment). now i want to calculate the multiplication of the space area and the sq m cost in the additional column i've added to the listing (column 'e'). the simple multiplication doesn't work, the monetary values (it's not dollars ) seem to have a different cell value, although i set it to number (here: decimal) and they sum to the spaces' count (41). another thing is the overall sum i wanted to have down the column 'e'. how can i retrieve these values to handle them properly? can anybody help? thanks, rob Quote Link to comment
michaelk Posted October 29, 2013 Share Posted October 29, 2013 (edited) I'm guessing that that 'Space'.'11_User-Def Info 1' is text field in the record format. To change the value to a number try =VALUE('Space'.'11_User-Def Info 1') hth mk Edited October 29, 2013 by michaelk Quote Link to comment
gester Posted October 29, 2013 Author Share Posted October 29, 2013 yes, you are right again and it's my miserable excel skills, sorry. unfortunately there's no field format assignment in the user-defined parameters' dialog options for the space object. thanks a lot, rob Quote Link to comment
michaelk Posted October 29, 2013 Share Posted October 29, 2013 Native Vectorworks parametric objects like spaces or windows or doors, etc. have "hidden" record formats. My understanding is that they behave like the record formats you create yourself, but they are just hidden.. There's no reason you couldn't attach your own record format to the space objects with a number formatted field to hold the cost per square meter data and use it the same way you are using the user field, but with a more agreeable format. mk 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.