Has anyone ever had luck using an analytic functio...
# suiteanalytics
b
Has anyone ever had luck using an analytic function like RANK or DENSE_RANK in a saved search criteria?
m
I think it’s possible as long as it’s not a summary search. But non summary searches support this
b
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)