Hello, colleagues!
A client has asked me to remove the hyphens (-) from the tables and leave a blank space.
Does anyone know if this is feasible without affecting the fact that it is a numeric field used for averages?
Thank you so much in advanced!
Welcome back @elk-user-0001.
I'm not sure of a way to change it to a blank while keeping it numeric. You could make it 0 using the numeric formatting alongside an ifelse
similar to the below:
The number format uses a similar syntax to numerical.js, as discussed here if you want to try playing with a custom format.
Hope that helps!