Light Instrument Weight Summary Worksheet

[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

[Pat Stanford]

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.

[Dylan Jones]

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

[Pat Stanford]

I did download it and tried it. It worked in your file. My edit attached.

 

 

Weight Summary Report. Errorvwx.-Stanfordvwx.vwx

[Pat Stanford]

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.