topic Re: Functions: beam lenght and column height -> value in Collaboration with other software

Functions: beam length and column height -> value

KNA — Sun, 27 Jun 2021 09:33:20 GMT

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

Re: Functions: beam lenght and column height -> value

Podolsky — Sun, 27 Jun 2021 10:06:51 GMT

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.

Re: Functions: beam lenght and column height -> value

KNA — Mon, 28 Jun 2021 06:05:37 GMT

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.

Re: Functions: beam lenght and column height -> value

James B — Mon, 28 Jun 2021 11:19:06 GMT

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

Re: Functions: beam lenght and column height -> value

Podolsky — Mon, 28 Jun 2021 16:44:23 GMT

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.

Re: Functions: beam lenght and column height -> value

Laszlo Nagy — Wed, 30 Jun 2021 11:11:59 GMT

I just tried this and if you use the "3D Length" general parameter it will return the correct value for both Columns and Beams, even if they are inclined. So I think there is no need for expressions or even new Properties, you can just use the "3D Length" general parameter in your schedule.

Re: Functions: beam lenght and column height -> value

jl_lt — Wed, 30 Jun 2021 14:35:24 GMT

KNA wrote:
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

Hi, im wondering, why just not have a schedule for beams and another one for columns?