Samuel Derenboim Posted November 29, 2017 Share Posted November 29, 2017 (edited) 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 November 29, 2017 by Samuel Derenboim Quote Link to comment
Pat Stanford Posted November 29, 2017 Share Posted November 29, 2017 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. Quote Link to comment
Samuel Derenboim Posted November 29, 2017 Author Share Posted November 29, 2017 (edited) 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 November 29, 2017 by Samuel Derenboim Quote Link to comment
Pat Stanford Posted November 30, 2017 Share Posted November 30, 2017 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. ;-) 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.