Jump to content
Sign in to follow this  
ewalker

Filter Values from Area Schedule

Recommended Posts

Is it possible to add a filter to the database header so that a column only shows the values for the objects that have the required field value attached to it?

For example, I used the formula =('Space'.'Area') which listed the net area for ALL the spaces in the file. I want all the spaces to be listed. However, in a particular column, I only want to show the values for the spaces that have the field value Enclosed Liv in the attached record Space Schedule as Yes. So I tried the formula =('Space'.'Area') & ('Space Schedule'.'Enclosed Liv'='Yes') but it only gave either True or False as the result, instead of the numerical value for the net area.

I am looking for a result similar to the image shown.

Edited by ewalker

Share this post


Link to post

'Enclosed Liv in the attached record 'Space Schedule' as Yes ... which is text...

but you are requesting "the numerical value for the net area"

Hence the boolean True or False ... indicating that the field queried 'Enclosed Liv' contains data.

Share this post


Link to post

Try this as the formula for the column.

=IF('Space Schedule'.'Enclosed Liv'='Yes', space.area, ' ')

You probably will not get the proper summation in the column header as it seems to add 1 for each blank row.

Share this post


Link to post

Pat:

That worked beautifully! The only problem is that in the SQ. M. column, I cannot multiply the result (the empty cell) by a number (0.0929), as shown in the database header in the image. I keep getting #VALUE! as the result, instead of an empty cell.

This also messes with the end total, with it also giving the result as #VALUE!.

Share this post


Link to post

I think you are going to have to live with zeros in those cells instead of blanks. Change the formula to:

=IF('Space Schedule'.'Enclosed Liv'='Yes', space.area, 0)

this is a zero at the end.

That will make sure that every cell has a number in it instead of some having numbers and some having text. You are getting the Value result because you are doing arithmetic on a text field (the '') instead of a number. That bad result is then propogating to you final columns.

The only other possibility would be to modify your formulas in the m2 columns to use an if and not calculate if the ft2 column is blank. Not tested, but maybe something like:

=if(D2='','',D2*10.78)

I don't know if this will work for your grand totals or not.

Share this post


Link to post

Pat:

The if function still works, but I got the SQ. M. column to also work by using =D4*0.0929 as the formula. Thanks a lot for the quick response.

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