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

The 2025 Technology Preview Program is now live. Join today!

Schedule zero values options

magkuj
Contributor

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

This wish has made it onto our Product roadmap!

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
Contributor

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 7 Votes

Wish details