RevitCity.com Logo

Home  |  Forums  |  Downloads  |  Gallery  |  News & Articles  |  Resources  |  Jobs  |  FAQ  |  SearchSearch  |  Join  |  LoginLogin

Welcome !

176 Users Online (175 Members): Show Users Online - Most ever was 626 - Mon, Jan 12, 2015 at 2:00:17 PM

 

Forums

Forums >> Revit Building >> Technical Support >> help with a if and yes/no formula

Search this ThreadSearch this Thread | Page 1 of 1 |

Mon, Mar 21, 2011 at 9:47:29 AM | help with a if and yes/no formula

#1

jmqrsq


active

Joined: Thu, Oct 20, 2005
168 Posts
5 Stars: 3 Votes


So here is what I have. In a window family I have a window pane family nested into my main double window family. In the window single unit family I have 4 yes/no parameters that will report the glass type by type to a schedulable format.

One yes/no for each of the four types, "Spandrel", "Clear", "Obscure" and "new".

Basically I want the main window family to be able to be tagged by two custom shared parameters called "Left Side Pane type" and "Right Side Pane type". The tag works like it should but now I want to let the family type auto fill in the correct tag for each of the Pane type tags. "R1" for Clear glass replacement, "R2" for Obscure glass replacement, "r3" for Spandrel glass replacement and "N1" for New clear glass replacement.

My formula now is: or(Clear Pane,"R1", or(Spandrel Pane=1,"R3", or(Opaque Pane=1,"R2","unknown"Winking)) and I keep getting a "improper use of boolean expressions" error. I just want the tags to be correct based on what two glass materials are being used as type parameters. The tag would be in this format for the windows: R1/R2 or N1/N1 or R2/R3 etc. Can anyone suggest what my formula problem is?

 

thanks in advance


This user is offline

 

Mon, Mar 21, 2011 at 9:50:31 AM | help with a if and yes/no formula

#2

jmqrsq


active

Joined: Thu, Oct 20, 2005
168 Posts
5 Stars: 3 Votes


here is a screenshot of my parameters and the expected result for the example....

Attached Images

90123_window.JPG

This user is offline

 

Mon, Mar 21, 2011 at 10:20:03 AM | help with a if and yes/no formula

#3

thetabest


active
thetabest Avatar

Joined: Tue, Mar 15, 2011
199 Posts
3 Stars: 2 Votes


try using the following:

if(Clear Pane, "R1", if(Spandrel Pane, "R3", if(Opaque Pane, "R2", "unknown"Winking))

 Also, your parameter 'Right Pane Type' needs to be of a text type.

What you were doing with the or( , , ) statements wasn't what you wanted... you were saying:

Clear Pane OR "R1" OR Spandrel Pane OR "R3" OR Opaque Pane OR "R2" OR "unknown"

the error stems from trying to assign a boolean value to a text parameter.  The only return of an OR function is true or false.  Thus I modified it to be an IF statement, which works as you want it, i.e.- if( <expression to be evaluated>, <return value if true>, <return value if false>Winking

 

Hope this all helps, also, you don't necessarily need this equation for what you are creating UNLESS it is an instance parameter, but the type of glass you have in your window lends it to be a type parameter, and when you define the "Spandrel" type, put "R3" as the value of Right Pane Type.  I really hope this helps, pay special attention to the usage of equations, they take processing power, and can cause your project to run much slower.  Typically, if I'm using an equation, it tends to be on an instance based parameter, one that can change often, whereas with my type based parameters, I just input the expected value of each type (Granted, if I used equations I could "Lock" the parameter from prying user eyes...).


-----------------------------------

Trent Best

Best Systems

the.tabest@gmail.com

This user is offline

 

Search this ThreadSearch this Thread | Page 1 of 1 |



Similar Threads

Thread/Thread Starter

Forum

Last Post

Replies

Using schedule total in formula?

Revit Building >> Technical Support

Fri, Apr 4, 2014 at 10:29:50 AM

9

One family parameter has formula one has none

General Discussion >> Revit Project Management

Wed, Jun 25, 2014 at 1:05:54 PM

7

Parameter Formula

Revit Building >> Technical Support

Fri, Mar 5, 2010 at 12:09:09 PM

6

need help with a formula for my calculated value

Revit Building >> Technical Support

Thu, Jan 30, 2014 at 1:03:02 PM

2

Formula Help

Revit Building >> Technical Support

Thu, Aug 10, 2006 at 9:34:15 AM

1

Site Stats

Members:

1995755

Objects:

22885

Forum Posts:

152175

Job Listings:

3

Sponsored Ads

Home | Forums | Downloads | Gallery | News & Articles | Resources | Jobs | Search | Advertise | About RevitCity.com | Link To Us | Site Map | Member List | Firm List | Contact Us

Copyright 2003-2010 Pierced Media LC, a design company. All Rights Reserved.

Page generation time: 0.2501

Login

User Name:

Password:

Remember Me  

Forgot Password?

Search Forums

Advanced Search

Search Forums

Advanced Search


Clear Highlights


Clear Highlights