Collaborate forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Problem: Values in expressions multiplied by quantity in schedules

Jakub S
Newcomer
Hi!
I'm struggling with this problem.
I've created schedules of construction elements (beams and columns) where I'm listing their lengths and heights.
I needed rounded up values with some reserve. For this, I'm using expression MROUNDUP. For single elements everything works like a charm, but problem appears with multiple elements of the same length.
I've got this schedule where all elements are listed and "merge uniform" option is "on" and in this case, the property I made is useless - values from expression are multiplied by number of elements.
To be sure, I made column with property containing expression of just the beam length and it also shows beam length multiplied by the number of beams with the same length.
My question is, why values based on expressions listed in schedules are working differently from those listed directly in schedules? Is there any workaround? I was thinking of dividing the result by number of elements, but this number is specific for schedule and cannot be used in expressions...
7 REPLIES 7

Podolsky
Newcomer
Scheduling is not so advanced tool and this is why similar problems appear. Try to solve it differently - don't round up the values with property for example. Use calculation rules and units settings instead.

Jakub S
Newcomer
Podolsky wrote:
Scheduling is not so advanced tool and this is why similar problems appear. Try to solve it differently - don't round up the values with property for example. Use calculation rules and units settings instead.
This is not a solution for what I’m trying to achieve and will produce more problems in other schedules, but thanks.

Laszlo Nagy
Community Admin
Community Admin
Length type Properties will be added in Schedules when the "Merge Items" checkbox is checked.
Number type Properties will not be added when the "Merge Items" checkbox is checked.

So, the solution is to create a Number type Property instead of a Length type Property.
There is a pretty elegant solution to convert a Length type Property to a Number type Property.
Let us say you want to convert the "3D Length" Property. It would look like this (in the case of a Metric system):

3D Length / 1 m
....................................................................................................
Laszlo Nagy, Lead Moderator, Community Admin
Get Archicad Tips at https://twitter.com/laszlonagy
AMD Ryzen 1700X CPU, 48 GB RAM, NVidia GTX 1060 6GB, 500 GB NVMe SSD
2x28" (2560x1440), WIN10 PRO ENG, AC20-AC25
Loving Archicad since 1995

Jakub S
Newcomer
LaszloNagy wrote:
3D Length / 1 m
Brilliant. Although using 3d length creates the same, multiplying problem with "merge items" option checked. I'm using "MAX" of left and right side length (for beams) and "max height" for columns.
Side question: is there any way to control displayed accuracy for number parameter?

Laszlo Nagy
Community Admin
Community Admin
I think the only way to control the exact decimal places of value is if you convert them to string type of Property and then use text manipulation commands to achieve the desired decimal places display.
....................................................................................................
Laszlo Nagy, Lead Moderator, Community Admin
Get Archicad Tips at https://twitter.com/laszlonagy
AMD Ryzen 1700X CPU, 48 GB RAM, NVidia GTX 1060 6GB, 500 GB NVMe SSD
2x28" (2560x1440), WIN10 PRO ENG, AC20-AC25
Loving Archicad since 1995

Jakub S
Newcomer
Hmm... but then I loose possibility to sum up values.
Expression based properties in schedules definitely need tweaking.

Laszlo Nagy
Community Admin
Community Admin
Yes, it has its limitations, such as the one you mentioned.
I think the best solution would be to be able to optionally define the formatting and accuracy on a Schedule Field level in the Scheme Settings Dialog (or use the settings coming from Calculation Settings preferences).
....................................................................................................
Laszlo Nagy, Lead Moderator, Community Admin
Get Archicad Tips at https://twitter.com/laszlonagy
AMD Ryzen 1700X CPU, 48 GB RAM, NVidia GTX 1060 6GB, 500 GB NVMe SSD
2x28" (2560x1440), WIN10 PRO ENG, AC20-AC25
Loving Archicad since 1995

Still looking?

Browse more topics

Back to forum

See latest solutions

Accepted solutions

Start a new discussion!