cancel
Showing results for
Did you mean:
cancel
Showing results for
Did you mean:
BIM Coordinator Program (INT) April 22, 2024

# Find the next step in your career as a Graphisoft Certified BIM Coordinator!

Collaboration with other software
About model and data exchange with 3rd party solutions: Revit, Solibri, dRofus, Bluebeam, structural analysis solutions, and IFC, BCF and DXF/DWG-based exchange, etc.

# Functions: beam length and column height -> value

Participant
Hello,
I have a schedule that has properties from both beams and columns. I would like to have a column in the schedule that represents either beam lenght or column height depenging on which one is on the row. I used (STRTONUM(STRCALCUNIT... to get numbers from both element types but do I use to get the schedule to show the number in both cases? The logical sentence is something like "if value is "--" then show the other value and vice versa... )
Thanks!
KN
6 REPLIES 6
Ace
Your property expression probably must have this logical structure:

IF element=column THEN value=column height ELSE IF element=beam THEN value=beam length

Check which exactly commands you need to use. I'm not sure, that converting string to number can help you somehow.
Participant
Thanks!

I got it to work by using two rows with the following (I´m using Finnish version, so not sure about the trasnlations).

IF (element="column"; columnheight; 0 m)
IF (element="beam"; beamlenght; 0 m)

I was just wondering is there a way to have this in one logical structure like you wrote -> how do you use ELSE IF as a command? I tried IF (element="column"; columnheight; beamleght) but it didn´t work.
Graphisoft
An easier way to combine them is:
Data Type = Length
Expression.
- add 2 items to the list, one is Beam "3D Length" and the second is Column "Height"

Then assign this new Property to just Beams and Columns (classification).
Graphisoft Senior Product Manager
Ace
You can use IFS instead of IF. IFS let to have several conditions:

IFS ( LogicalCondition 1, Value1, [LogicalCondition2, Value2],...)

IFS (element='column', columnheight, element='beam', beamlength)

Actually, strange why IF (element='column', columnheight, beamlength) is not working. Logically here everything correct - if element is not column, then it shows length of beam.