topic Re: No 'Show zero values' in schedules in Collaboration with other software

No 'Show zero values' in schedules

Ignacio Azpiazu — Wed, 22 Apr 2020 01:47:22 GMT

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.

Re: No 'Show zero values' in schedules

Laszlo Nagy — Thu, 23 Apr 2020 21:03:00 GMT

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.

Re: No 'Show zero values' in schedules

Ignacio Azpiazu — Thu, 23 Apr 2020 21:28:01 GMT

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.

Re: No 'Show zero values' in schedules

Laszlo Nagy — Fri, 24 Apr 2020 00:07:06 GMT

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.

Re: No 'Show zero values' in schedules

Ignacio Azpiazu — Fri, 24 Apr 2020 03:53:21 GMT

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.

Re: No 'Show zero values' in schedules

Laszlo Nagy — Sat, 25 Apr 2020 11:33:23 GMT

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.

Re: No 'Show zero values' in schedules

Ignacio Azpiazu — Sun, 26 Apr 2020 17:17:27 GMT

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.

Re: No 'Show zero values' in schedules

Laszlo Nagy — Mon, 27 Apr 2020 00:25:28 GMT

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