No 'Show zero values' in schedules

[Ignacio Azpiazu]

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.

[Laszlo Nagy]

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.

[Ignacio Azpiazu]

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]

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.

[Ignacio Azpiazu]

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]

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.

[Ignacio Azpiazu]

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]

Good idea. If you do make a wish, please post its link in this thread.