<@U412EABU2> Investigate using Dense_rank in a cri...
# general
m
@sam1128 Investigate using Dense_rank in a criteria formula. Here’s an example from SuiteAnswers CASE WHEN (DENSE_RANK() OVER (PARTITION BY {name} ORDER BY {trandate} DESC) < 3) THEN 1 ELSE 0 END is equal to 1