Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm trying to do some ranking for my work. The rank function should be on the date field per account number,
which means that 10.1 should rank with 1, 12.2 with 2 and etc..
I've searched and read that the rank function goes with the aggr function, but that's not my case here
thanks a lot for any help
Omer
Hi,
Examp..
1) Aggr(Rank(Aggr(Sum(totalamount), accountnumber), 1, 1),accountnumber)
2) avg(aggr(rank( sum( {$<accountnumber=>} totalamount) ), accountnumber))
3) rank( sum( {$<accountnumber=>} totalamount) )
4)RowNo()
What is your Rank Expression here? Have you tried just this Rank(date)
Hi,
Thanks for the examples,
Is there any expression in your examples that I can change that will contain both the date and the account number?
Hi,
the expression is - rank(date,account number)
but it's not working:)
if I'd do rank(date) , I'll get a rank all over the dates and not per account number
Have you tried Rank(date)? At least give it a shot and see if it gives you what you want.
Try using
Aggr(rank(Date),account number, Date)
Thanks!! this expression work combined with the sort tab
If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).
If not, please make clear what part of this topic you still need help with .