This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
Product Feedback Forum
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย
- Community
- Product Feedback
- Working with NULL values
Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Status:
New Idea
Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
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
See more ideas labeled with:
