Join Slack
Powered by
<@U412EABU2> Investigate using Dense_rank in a cri...
# general
m
markderrick
03/15/2018, 3:12 PM
@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
2
Views
Open in Slack
Previous
Next