Learn to manage BIM workflows and create professional Archicad templates with the BIM Manager Program.

Schedule zero values options

magkuj
Participant

Hey!

According to Polish Norm I have to qualify zones to different categories and for that I use the expression and IF statements in property manager.

Thanks to that in schedule the area of the zone shows in a column of the assigned category, unfortunately for other categories it shows "0.00" value, which makes the schedule unclear, especially with a long list of rooms.

It would be great to have an option that lets you leave the zero value cells empty.


Screenshot.jpg
3 Comments
James B
Graphisoft
Graphisoft
Status changed to: On roadmap

We are already working on this as listed here on our roadmap - https://community.graphisoft.com/t5/Product-Roadmap/Interactive-Schedule-formatting-and-UI-improveme...

 

Andras Fabian
Graphisoft
Graphisoft

Hi, I wonder how does your expression look like? I'd expext "--" for other categories, rather than 0

magkuj
Participant

Hey! Thank you for engaging! It's quite extensive (I'm not sure, maybe too much) and I wasn't able to fix it the way the result would be more satisfying:

 

IFS ( {Property: A} = "Cat.A"; {Property: Area}* 0; {Property: A} = "Cat.B"; {Property: Area} * 0; {Property: A} = "Cat.C"; {Property: Area} * 0; {Property: Area} = "Cat.D"; {Property: Area} )

 

This formula works well enough to give me results from the screenshot and is repeated in every category, just changed accordingly from A to B to C to D.

I tried to add another extra expression that would simply give a result IF 0 THEN "-" or " " using tips from forum discussions and chat gpt and it always gave me errors...

Status
On roadmap

with 0 Votes

Wish details