Multiply Quantity using Expressions

JCCARLOS91 — Thu, 02 Nov 2023 09:20:04 GMT

Hi,

I am trying to calculate for parking requirements for various apartment types.

Right now, I've created a schedule that counts the number of zones plotted in each apartment unit. Ideally, one unit (meaning one zone) equals to just one count of parking. But in the 2 bedroom apartments, there is a requirement of 2 parkings per unit.

How can I create an expressions that multiplies the count of a zone into 2 or 3?

Re: Multiply Quantity using Expressions

AllanP — Mon, 04 Dec 2023 01:13:25 GMT

I assume that you are using different Zone Categories for apartment units

so:

add an integer property and

add the expression:

IF ( {Property:Zone/Zone Category} = "1 BED", 1, IF ( {Property:Zone/Zone Category} = "2 BED", 2, IF ( {Property:Zone/Zone Category} = "3 BED", 3, 0 ) ) )

which will give you a 0 if the value is not "1 BED" or "2 BED" or "3 BED"

or you could use

IFS ( {Property:Zone/Zone Category} = "1 BED", 1, {Property:Zone/Zone Category} = "2 BED", 2 ,{Property:Zone/Zone Category} = "3 BED", 3 ,TRUE, 0)

which will give you an 0 if the value is not "1 BED" or "2 BED" or "3 BED"

add the field from " parameters and properties"

then sum the properties,

and "Hey Presto, you have baked a cake..."

I hope this is useful.

P.S.

using if statements:

file:///C:/Program%20Files/GRAPHISOFT/ARCHICAD%2025/Help/Files/index.htm?rhcsh=1&rhnewwnd=0#t=_AC25_Help%2F061_ExpressionFunctions%2F061_ExpressionFunctions-18.htm&rhsearch=ifs&rhhlterm=ifs&rhsyns=%20

topic Re: Multiply Quantity using Expressions in Project data & BIM

Multiply Quantity using Expressions

Re: Multiply Quantity using Expressions