Jump to content
  • 0
GlueDT92

Using Worksheets to Count Stanchions

Question

I have multiple stanchion objects in a drawing & am trying to easily count the total number of stanchions required using a worksheet, but I cant seem to get the total to sum. Ideally my current 38 line database row would be summarized as a single sum total number, but when I use the sum values & summarize items check boxes it just returns me a -- instead of a number.

 

 

Stanchion Test.vwx

Share this post


Link to post

3 answers to this question

Recommended Posts

  • 0

It looks like the Stanchions field is stored as text rather than as a number.

 

Try changing your column B formula to =VALUE('Rope and Stanchion'.'TTLStanchions')

 

If you then set column A to =OBJECTTYPENAME and SUMmarize on Column A, you can then Sum Values on Column B to get a single subrow showing a total of 571 stanchions.

 

You will need to do the same for ropes, belts and chains. All are stored at text.

 

  • Like 2

Share this post


Link to post
  • 0

@Pat Stanford Yup, that worked perfectly. Out of curiosity, how were you able to tell that the data was being stored as a text value instead of a number?

 

 

Share this post


Link to post
  • 0

1. 20 years of fighting VW on data stored as text.

2. I tried the Value() thing and it worked.

3. What I should have done in the first place was run my handy dandy script that shows you the data type of each field of a PIO parameter record. You probably should skim the entire thread to make sure you get the latest version of the script and the notes on how to use it.  Place a single instance of the PIO directly on a design layer and run the script. It will generate a worksheet showing all of the parameter fields of the PIO.

 

 

  • Like 3
  • Laugh 1

Share this post


Link to post

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.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


 

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.

×
×
  • Create New...