I have discovered that simple formula fields retain formatting options. For example, something like:
{Hours}*{Hourly rate}
…may be formatted as a currency with a preferred level of precision and currency symbol.
But more complex formulas, such as those with conditional logic, do not have formatting options available. For example:
IF( {Hours}=0, "", "£"&{Hours}*{Hourly rate} )
…is formatted as left-aligned text whether one likes it or not, even though the result is intended as a currency value.
In my example, all I am trying to achieve is to prevent empty {Hours} values from getting reported as £0.
So it would be great if formulas that can retain formatting options were provided a checkbox to Hide NULL values. I use the word ‘NULL’ here to mean any value that equates to empty:
“” in an empty text field
0 in an empty numeric field
There may be other values worth embracing such as “FALSE” or “NULL”
There will be times when people do want empty value to be visible, which is why I propose this as an option.
... View more
