2024-11-04 12:04 PM
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
Solved! Go to Solution.
a month ago
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.
2024-11-04 12:30 PM - edited 2024-11-04 12:38 PM
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!
a month ago
Nope, tried that.
a month ago
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 )
a month ago
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....
a month ago
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.
a month ago
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.
a month ago
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.