Conditional Statements - reading information from another parameter

[yuliya.nenovaWUZQN]

Hi everyone,

I have a door schedule where I want to show the wall material and thickness in a "combined" way, meaning: I want to have columns with several material types (concrete, brick, gypsum etc.) and show the wall thickness below in each door instance raw under the related material. Sofar I've created a wall thickness parameter and material type parameters as a yes/no parameter. Is it possible then, to use a conditional statement in a parameter that requires when the material is correct, to show directly the wall thickness, and when it's wrong, to leave the cell empty? I tried with if(material, thickness, "") but it's showing me wrong Unit. Does anyone know how to solve this/how is the proper structure of the formula? Any better ideas are welcomed too.

p.s. attached you can find a schedule from excel showing what I want to achieve - cells in red are material types and in green I marked a type which is showing wall thickness information - to be understand as all doors are in the same wall type with the same wall thickness.

Thanks in advance!

[ToanDN]

Are you trying to show the door frame depth or throat width? If so, you
can use a shared reporting parameter in the family to report the host wall
thickness and add it to the schedule.

[RDAOU · Accepted solution]

@yuliya.nenovaWUZQN 

Thickness is a Length parameter..  "" is a text field ... you cannot combine Length and Text in a conditional statement.  It has to be either / or 

If you want that to work, the Length would need to be a text parameter too ie: input manually or using Dynamo.

Otherwise, instead of "" will need to be you will have to settle for the integer 0...a blank cell wont work with length

[barthbradley]

---

@yuliya.nenovaWUZQN wrote:

Hi everyone,

I want to have columns with several material types (concrete, brick, gypsum etc.) and show the wall thickness

---

I don't understand why you want the thicknesses of Wall Types' individual layers computed and reported in a Door Schedule.  I can't think of one valid reason to include that information in a Door Schedule, but you could compute and report those values in a Wall Material Take-off.  

See Calculated Parameter "Thickness" in below screenshot:  

[yuliya.nenovaWUZQN]

Thank you very much!