I get stuck on this seemingly simple expression...

[Mats Knutsson]

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

[runxel]

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!

[Mats Knutsson]

Nope, tried that.

[Yves]

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 )

[Mats Knutsson]

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

[Barry Kelly · Accepted solution]

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.

[Mats Knutsson]

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.

[Xandros]

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.