Expression Filter to Filter to MAX Date

JobDeLuna · Oct 6, 2025 7:50PM

Hi,

Request any help the possibility for an expression filter to filter to the MAX Date.

"SCST - Savings Impact Reporting"."Time"."Snapshot Date"

Jestin Rajan · Oct 7, 2025 1:24PM

Hi,

You can use the TOPN function to get the MAX date. It should do the trick!

TOPN(CAST("SCST - Savings Impact Reporting"."Time"."Snapshot Date" AS DATE), 1) = 1

Let me know if you face any challenges while implementing it.

JobDeLuna · Oct 7, 2025 2:13PM

Thanks @Jestin Rajan !!! It worked

Jestin Rajan · Oct 7, 2025 2:32PM

Happy to help! 😊

Oracle Fusion Data Intelligence