Using Maximum Date Filter With Null Values

[fonzndav]

thread401-1300019

This solution works in my case as long as there are valid date values in the row returned. I am using multiple dimensions that sometimes returns rows where the date in question (comments) is null because there are no comments for the record reported. In this case since the comment date is null, the row is excluded, which is not what I want.

Can I use a conditional filter where I use the Maximum Date function when comment data is present?

Thanks.

 

[blom0344]

Perhaps the easiest approach is to use a union. The first set works exactly like the current setup, whereas the second set just fetches the rows where date is null..

Ties Blom