Custom Filter Containing IF condition

[aznamierowski]

Hello,

I'd like to filter to any records where the Reopened Date > 365 days, and if the Reopened Date is NULL, on records where the First Found Date > 365 days.

Can someone show me how I'd write a Custom Filter accordingly?

I want to do Totals so a Custom Calculation (if${Reopened Date}>{First Found Date},{Reopened Date},{First Found Date}) to reference in the Custom Filter is out of the question.

I don't think I can do something like:

(add_days(365,(if${Reopened Date}>{First Found Date},{Reopened Date},{First Found Date}))) < now()