Filter Using No. of Days

Hi, I've been filtering revenue to appear or not in a cell depending when it was last updated.  This had been working really well until a %discount got involved!

This is the fomula:

FILTER(CASE WHEN "- CustomObject9 Custom Attributes".ZPick_0 = 'ON' THEN CASE WHEN ("- Custom Percent(CustomObject9)".ZNum_20 is null OR "- Custom Percent(CustomObject9)".ZNum_20=0) THEN "- CustomObject9 Custom Metrics".S_INDEXED_CUR_0 ELSE  "- CustomObject9 Custom Metrics".S_INDEXED_CUR_0*("- Custom Percent(CustomObject9)".ZNum_20/100)  END ELSE 0 END USING (TIMESTAMPDIFF(SQL_TSI_DAY, CustomObject9."Indexed Date 0", CURRENT_DATE) <=180 AND TIMESTAMPDIFF(SQL_TSI_DAY,CustomObject9."Indexed Date 0", CURRENT_DATE) > 90))