Andrew Davies Posted October 1, 2017 Share Posted October 1, 2017 (edited) Hi I have loads of rope and post (stanchion) I've added to my drawing using the Rope and stanchion tool. What's the best way of counting how many posts all together? Thanks, Andrew Edited October 1, 2017 by Andrew Davies Quote Link to comment
grant_PD Posted October 1, 2017 Share Posted October 1, 2017 Create report, list objects with record "rope and stanchion" look for "total stanchion" Quote Link to comment
C. Andrew Dunning Posted October 2, 2017 Share Posted October 2, 2017 This might help. See the use of "Value." Regards - Part_Counts.vwx Quote Link to comment
Andrew Davies Posted October 3, 2017 Author Share Posted October 3, 2017 Many thanks both - appreciated. Quote Link to comment
Andrew Davies Posted October 15, 2017 Author Share Posted October 15, 2017 Thanks again for this - really helpful. Just got round to using it 😳 and am struggling to get dimensions (Total Length) and quantity to work. It seems as if the report adds the dimension and quantity as text (so 3,000mm as opposed to 3000) meaning I can't do a sum of a column without pasting it into Excel and manually removing the mm. I am doing something wrong , I just know - but can't work out what! Andrew Quote Link to comment
Pat Stanford Posted October 17, 2017 Share Posted October 17, 2017 Try setting your formula to get the length to: =VALUE('Rope and Stanchion'.'TTLStrngrLngth') And formatting the cells as a Dimension. That should give you both a numeric value that can be summed and the proper unit mark. 1 Quote Link to comment
Andrew Davies Posted October 18, 2017 Author Share Posted October 18, 2017 Thanks Pat - that's perfect. Not obvious though - but thanks. I was using the following dialogue box to sum the values - but it didn't work. What are those options for? Andrew Quote Link to comment
Pat Stanford Posted October 19, 2017 Share Posted October 19, 2017 Nothing is obvious until you have done it. You can pretty much assume that anything coming from a record that has units attached to it is in a TEXT format, not a Number format. If that is the case, you will need to use the VALUE function to convert it to a number before you can do any math on it. There is a script floating around that I wrote that will create a worksheet of all of the available fields of a PIO and there data type. Search for "Worksheet of PIO Fields" or let me know and I will track it down for you. 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.