isNan/whenNan formulas
We should introduce 2 new formula functions:
-
isNan(value)
- returns
True
whenvalue
isNaN
- return
False
otherwise
- returns
-
whenNaN(value, fallback)
- returns
value
ifvalue
is notNaN
- returns
fallback
ifvalue
isNaN
- returns
The need for these formula functions originated from https://gitlab.com/bramw/baserow/-/issues/1054 because we thought that it would be nice to deal with a cell being NaN
.
At the moment when you run an aggregation over loads of rows and one of them is NaN
the aggregation won't give you a result. But if you can decide as a user how the system should handle NaN
values you can make sure that you can still aggregations the way you want to even with faulty values.