try grouping on a formula(text) that converts miss...
# suiteanalytics
j
try grouping on a formula(text) that converts missing due date into a text value maybe
nvl({duedate}, 'no due date')
n
it doesn't seem like nvl() likes text fields.
k
Case when {duedate} is null then 'no due date' else {duedate} end
You might have to do a to char on due date
1000 1
s
The biggest issue with CASE or NVL is that every possible return value must be of the same data type, since they will all be in the same output column, so if you are using NVL on a date field, you either have to use a date for the null result, or convert the date to a string (varchar) so that it is the same type as the 'no due date' null result.
k
Also, I think you can't drill down on custom formula columns
n
@KevinJ of Kansas That is true, just tested it. I'll have to throw another field to group on.