I'm looking for a clean formually which turns any value to 0 when the original value goes below 0.
I'm having a dashboard based on a log, and I need to do calculations in the front end (unfortunately) to come to a certain number. Sometimes, when selecting certain dimensions, I'm getting negative values which make sense according to the formula, but can't occur in the real world (eg: -3 registrations).
I could of course work with an if like this:
if(value <= 0, 0, value)
... but I wanted to know if their might be a cleaner way to do this as my "value" in the script above is actually a pretty large formula)
Ps: The value is shown in a text object in my dashboard