Product Feedback Forum
cancel
Showing results for 
Search instead for 
Did you mean: 
Status: New Idea

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