Working with NULL values | Product Feedback Forum

OleksandrB · 2024-01-16T16:40:38.906000Z

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]) = NULLIs 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

MoreDiscussions

Working with NULL values | Product Feedback Forum | Sisense Community