Use Custom Expression on Level Filter

Hi,

I need to use the following custom expression on level filter, both top level and drill-down level.

If(date_diff(sysdate(),$max_date_created)<>0,date_diff(sysdate(),$max_date_created),$date_creation)

Variables:

• $max_date_created = max(threads.entered)
• $date_creation = date_diff(sysdate(),max(incidents.created))

The above script works when used to filter the drill-down level as Group filter, but not for the entire report filter nor top level that only have 'prod_hierarchy' and 'count(distinct incidents.ref_no)' columns (see error message attached). When used as a Group filter on top-level it is pulling incorrect case count. Thus, I'm trying to apply it throughout all levels.