topic Betreff: I get stuck on this seemingly simple expression... in Project data & BIM

I get stuck on this seemingly simple expression...

Mats Knutsson — Mon, 04 Nov 2024 11:04:40 GMT

Hi,

I have properties and want to drive values from combinations of these properties but I can't figure out how to. Any takers?

Br,

Mats

Operating system used: Windows

Betreff: I get stuck on this seemingly simple expression...

runxel — Mon, 04 Nov 2024 11:38:15 GMT

Hi Mats, if you mean like the little formula beneath try something along the lines of:

IFS ( AND ( Type="A"; Material="yy";etc..); "100"; AND ( Type="B"; Material="zz";etc..); "200"; ... )

Hope that helps!

Betreff: I get stuck on this seemingly simple expression...

Mats Knutsson — Mon, 04 Nov 2024 15:28:49 GMT

Nope, tried that.

Re: I get stuck on this seemingly simple expression...

Yves — Mon, 04 Nov 2024 17:03:23 GMT

like this with a number type property

IFS ( AND ( {Property:Généralités/Type} = "A"; {Property:Généralités/Material} = "xx"; {Property:Généralités/Accessory} = "1" ); 100; AND ( {Property:Généralités/Type} = "B"; {Property:Généralités/Material} = "yy"; {Property:Généralités/Accessory} = "1" ); 200 )

Re: I get stuck on this seemingly simple expression...

Mats Knutsson — Mon, 04 Nov 2024 19:38:11 GMT

Got it to work. Thanks! Seems like the same code as Lucas suggested. I don't know went wrong earlier...

I get grey hair from the syntax and the editor....

Re: I get stuck on this seemingly simple expression...

Barry Kelly — Tue, 05 Nov 2024 00:27:55 GMT

I am not sure if it is applicable in this case, but I have found depending on the language version of Archicad or maybe your operating system, some need to use semi-colons as expression separators and others need to use commas.

Barry.

Re: I get stuck on this seemingly simple expression...

Mats Knutsson — Tue, 05 Nov 2024 07:44:44 GMT

I've got that settled so it was something else. I must have missed something somewhere.

I will write to full expression (it will be quite massive) in a text editor and then paste it into AC.

Re: I get stuck on this seemingly simple expression...

Xandros — Tue, 05 Nov 2024 08:09:49 GMT

Do note, that the ifs function might have a limit. It does have one in excel and I wouldn't be suprised if it has one in ArchiCAD expressions too.

https://support.microsoft.com/en-GB/office/ifs-function-36329a26-37b2-467c-972b-4a39bd951d45

I once had this issue of a massive expression with a few hundred conditions. ArchiCAD performance will suffer noticeably!

If you reach more than the maximum you'll have to get creative on how to implement the expression(s) and how to improve performance again.