OleksandrB's avatar
OleksandrB
Sisense Employee
01-16-2024
Status:
New Idea

Working with NULL values

Hi, for this moment we have such a behaviour:

sum(NULL * 10) = NULL but SUM(NULL * [id]) = [id]
in the same time if [id] have values (1,NULL) and we will do SUM([id]) = NULL

Is it possible to add some toggle in the system how to work with NULL values.

For example, if it is disabled it works as NULL is empty and SUM(NULL * [id]) = [id]

But if it is enabled, so all NULL should be works as in mathematic SUM(NULL * [id]) = NULL etc

No CommentsBe the first to comment