# Property Line PIO Area Summaries

## Recommended Posts

Good afternoon Everyone,

I'm having a real problem with calculating area summaries for the Property line plug in object. I've been trying a number functions additional to =('property line'.'area') in order to convert this string into a numeric value. I've tried =value, =area, =round, =num, =str2num, etc... and I can't for the life of me get it to work. Anyone had any similar problems - VW 2018 SP2

PS - I checked the VW forum records, there was a similar wishlist item, but for some reason =area function worked in that instance. Any help please?

Thank you in advance!

Edited by Samuel Derenboim

##### Link to post

In a worksheet database (Row 2, criteria = Record 'Property Line' is present) with the 'Propery Line'.'Area' field in cell A, the following formula in column B worked for me:

=VALUE(SUBSTRING(A2, ' ', 1))

The Substring splits the string in cell A2 in to substrings using the space character as the delimiter. The 1 tells it to use the first substring it finds.

So with an area field of "475.542  sq ft    ",  it returns 475.542 to the Value function giving you a number.

If you are not using sq ft as your unit, you may need to adjust the substring delimiter is there is not a spaces after the number. If you have something like 123.455m2, I would just us 'm2' as the delimiter.

##### Link to post

Pat, Thank you! Just modified your code to make it work in one column. Just make a worksheet column show this below:

=value(substring('property line'.'area', ' ', 1))

Just curious, why is this such a hassle for property lines? Couldn't they just make it originally a numeric function?

Edited by Samuel Derenboim

##### Link to post

Yes, it seems that "THEY" could do a better job of making the data accessible in the worksheet. The Space object used to be pretty bad. Most of the fields there now have both numberic and string versions.

Submit a wish to have numeric versions of all the necessary fields of the property line.

I think this actually comes from all record data actually being stored as strings. Only having a single version of the data to keep straight is very comforting to programmers. ;-)

## Create an account or sign in to comment

You need to be a member in order to leave a comment

## Create an account

Sign up for a new account in our community. It's easy!

Register a new account

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×

• KBASE