Help using Totals.Rank
Posted: Thu Dec 15, 2016 6:11 am
Can you help me use the Totals.Rank function? I have this syntax {Totals.Rank(Data, Details.Exp_ytd_units__funded_)}
my data band (Data) is ordered by the field I'm ranking (Details.Exp_ytd_units_funded_) in desc.
I need to reverse the order of the ranking. Here is an example of what I currently get
YTD.............. Rank
$100,000............. 5
$75,000...............4
$50,000 ..............3
$25,000 ..............2
$5,000 ...............1
And I need the results look like this
YTD Rank
$100,000...............1
$75,000...............2
$50,000...............3
$25,000............... 4
$5,000................ 5
Thank you!
my data band (Data) is ordered by the field I'm ranking (Details.Exp_ytd_units_funded_) in desc.
I need to reverse the order of the ranking. Here is an example of what I currently get
YTD.............. Rank
$100,000............. 5
$75,000...............4
$50,000 ..............3
$25,000 ..............2
$5,000 ...............1
And I need the results look like this
YTD Rank
$100,000...............1
$75,000...............2
$50,000...............3
$25,000............... 4
$5,000................ 5
Thank you!