Jump to content
Sign in to follow this  
Roger Webster

Plant list

Recommended Posts

I have created a new descriptive plant list worksheet with fields including height, flower colour etc. All working fine in most cases, but in just a few instances the height given is wrong - ie it does not match the height given in the plant object description. I have tried editing the plant object description, both within the file I am working on and in the parent library file from which the plant object was imported, to no avail. Where else should I look?

Share this post


Link to post

I am sure Tamsin will jump in soon, she is on that side of the pond and is a fantastic resource for you.

Share this post


Link to post

Can you post a stripped down file with just a couple plants with the correct heights and a couple incorrect heights? And the worksheet.

Share this post


Link to post

a small sample file would certainly help, and without that just guessing. But my guess is That you might be looking in the wrong place for picking up the information about the plant size. what I'm trying to say is that when you look at the plant definition for the plant size, your worksheet might not be picking up the same field.

Share this post


Link to post

Have made a small sample file including some of the same plants and the same worksheet and it all works fine - heights in the sample file are correct. But they still remain incorrect in the other file. Not sure where or how I should attach the sample file?

Share this post


Link to post

Emailed reply. The issue is caused by the SUM function being applied to the Latin Name column. Because there is more than one instance of each plant, Vectorworks is also summing the height data. If you add the SUM function to the Height column, this will reverse the process. Have sent you an email with screenshots...

Best

T

Share this post


Link to post

Tamsin,

Is this a problem in VW 2009?

I sum by Latin Name Column often and have not had this problem

D

Share this post


Link to post

Yes, it's been a symptom of the summarise facility for a long time. If you summarise the results, numeric values such as price, height or spread will also be summarised. But you can add the sum to numeric columns and the worksheet will then display the original entered value.

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
Reply to this topic...

×   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.

Sign in to follow this  

 

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...