Dylan Jones Posted April 2, 2018 Share Posted April 2, 2018 Hi everyone I am having an issue trying to do a weight summary of my lighting fixtures in a worksheet. I understand the weight field is text and would not allow mathematical operations but previously I would just use the VALUE command to bypass this. e.g. =Value('Lighting Device'.'Weight') This command works perfectly in Vectorworks 2017. Does anyone have a way to get past this without creating a separate Record as i would like to make the transition into VW2018 smooth. See attached file with example. Vectorworks 2018 Designer Package Weight Summary Report. Errorvwx.vwx Quote Link to comment
0 Pat Stanford Posted April 2, 2018 Share Posted April 2, 2018 Try =Value(SubString('Lighting Device'.'Weight', ' ', 1)) There is a single space between the quotes in the middle parameter of the SubString. This is the delimiter to tell it where the number part stops and unit part starts. It is the units that are confusing the Value command. It only understands numbers. I think that VW2018 got "smarter" about understanding units besides length and area. So now the Weight field is defined as a "Weight" and brings the unit mark along. In VW2017, you could have a field that just had the number part and not the unit mark. Quote Link to comment
0 Dylan Jones Posted April 2, 2018 Author Share Posted April 2, 2018 (edited) Thank you so much Sir, I have a working version now. I did see many posts answered by you on this same subject matter years before. Really appreciate your help. Edited April 2, 2018 by Dylan Jones Quote Link to comment
0 Pat Stanford Posted April 2, 2018 Share Posted April 2, 2018 I did download it and tried it. It worked in your file. My edit attached. Weight Summary Report. Errorvwx.-Stanfordvwx.vwx Quote Link to comment
0 Pat Stanford Posted April 2, 2018 Share Posted April 2, 2018 Hit Submit too soon. Look at the edited Normal Weight Report to see exactly what I used to get the number part of the weight. Quote Link to comment
Question
Dylan Jones
Hi everyone
I am having an issue trying to do a weight summary of my lighting fixtures in a worksheet.
I understand the weight field is text and would not allow mathematical operations but previously I would just use the VALUE command to bypass this.
e.g. =Value('Lighting Device'.'Weight') This command works perfectly in Vectorworks 2017.
Does anyone have a way to get past this without creating a separate Record as i would like to make the transition into VW2018 smooth.
See attached file with example.
Vectorworks 2018 Designer Package
Weight Summary Report. Errorvwx.vwx
Link to comment
4 answers to this question
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.