Choose your top Archicad wishes!

Read more
Collaboration with other software
About model and data exchange with 3rd party solutions: Revit, Solibri, dRofus, Bluebeam, structural analysis solutions, and IFC, BCF and DXF/DWG-based exchange, etc.

No 'Show zero values' in schedules

Is there any way of not showing zero values? An IF expression will not allow me to show a space if the value if zero, because it wants the TRUE and FALSE values to be of the same kind.
7 REPLIES 7
Laszlo Nagy
Community Admin
Community Admin
Could you show an example of the desired result?
I reckon you will have to use Expression-defined Properties to achieve it, but let is see those screenshots first.
Loving Archicad since 1995 - Find Archicad Tips at x.com/laszlonagy
AMD Ryzen9 5900X CPU, 64 GB RAM 3600 MHz, Nvidia GTX 1060 6GB, 500 GB NVMe SSD
2x28" (2560x1440), Windows 10 PRO ENG, Ac20-Ac27
LaszloNagy wrote:
Could you show an example of the desired result?
I reckon you will have to use Expression-defined Properties to achieve it, but let is see those screenshots first.
The intended effect is that of Excel, Preferences>View, Window Options, “Show zero values” unchecked. Cells with value equal to zero show blank, as if empty. Sometimes you don't want to go that way, because in some cells showing zero does matter, or at least it tells you that nobody overwrote that formula etc., so I usually use IF formulas giving a space (" ") for formula result = zero TRUE, or showing the result for FALSE. I tried that in AC but I am told that an expression cannot have a text result (" ") if TRUE and a number or other calculation value if FALSE, they both need to be of the same type, or that is what I understood.
Laszlo Nagy
Community Admin
Community Admin
It is possible to do conversions from number to string, or to get the number value out of a string in Property Expressions.
So if you have a numeric value and a string value, I suggest you convert the numeric value to string so they both will be strings and then you will be able to perform the desired functions on them.
Loving Archicad since 1995 - Find Archicad Tips at x.com/laszlonagy
AMD Ryzen9 5900X CPU, 64 GB RAM 3600 MHz, Nvidia GTX 1060 6GB, 500 GB NVMe SSD
2x28" (2560x1440), Windows 10 PRO ENG, Ac20-Ac27
So the workaround would be to create a 'value converted to string for use only in schedules where one wants to produce this effect' property, and keep the 'true value' property for use in other expressions and schedules.
Laszlo Nagy
Community Admin
Community Admin
Yes, I think that could work.
Properties can be used like that. You can make Properties that are constants, or that store specific values, and are used in Expressions of other Properties. Their values do not have to appear in Labels or in Schedules.
Loving Archicad since 1995 - Find Archicad Tips at x.com/laszlonagy
AMD Ryzen9 5900X CPU, 64 GB RAM 3600 MHz, Nvidia GTX 1060 6GB, 500 GB NVMe SSD
2x28" (2560x1440), Windows 10 PRO ENG, Ac20-Ac27
Methinks I shall a wish make, for an on/off 'show zero values' option in schedule scheme settings. Unlike GDL, where one uses these workarounds for display and interface only, schedules use numbers for counts and sums, and columns with numbers converted to strings for-display-only kill that basic functionality.
Laszlo Nagy
Community Admin
Community Admin
Good idea. If you do make a wish, please post its link in this thread.
Loving Archicad since 1995 - Find Archicad Tips at x.com/laszlonagy
AMD Ryzen9 5900X CPU, 64 GB RAM 3600 MHz, Nvidia GTX 1060 6GB, 500 GB NVMe SSD
2x28" (2560x1440), Windows 10 PRO ENG, Ac20-Ac27