Has anyone ever had luck using an analytic function like RANK or DENSE_RANK in a saved search criteria?
m
MGBC
04/15/2025, 9:44 PM
I think it’s possible as long as it’s not a summary search. But non summary searches support this
b
Bryan Miller
04/15/2025, 9:49 PM
My formula works fine on results side but it unexpected errors on the criteria side. : RANK() OVER (PARTITION by {internalid} ORDER BY {custrecord_fam_asset.internalid} DESC)