This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.
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:
There will be times when people do want empty value to be visible, which is why I propose this as an option.