Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
group on null field
Migrateduser
Hi all
I have created a report on group on owner group , in the query have mentioned like
coalesce (ownergroup, NUll Group) when I Run report null group is displayed in the alphabetical order,
but when I run the query on the DB null group is displayed on the top
note : my query is like select field 1, field 2 , coalesce (field3)
if I group like count(field1), ownergroup from SR group by ownergroup , NUll group is diplayed on the top
thanks
Find more posts tagged with
Comments
There are no comments yet