cancel
Showing results for
Did you mean:
cancel
Showing results for
Did you mean:
BIM Coordinator Program (INT) April 22, 2024

Find the next step in your career as a Graphisoft Certified BIM Coordinator!

Project data & BIM
About BIM-based management of attributes, schedules, templates, favorites, hotlinks, projects in general, quality assurance, etc.

Multiply Quantity using Expressions

Enthusiast

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?

John Carlos
AC25 | iMac 2019

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

so:

``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: