
1. Re: Rank calculation
Peter Fakan Jan 22, 2019 12:53 PM (in response to Barb Reiser)Hi Barb,
I don't understand what your problem is  which formula are you having problems with ?
Peter


3. Re: Rank calculation
Barb Reiser Jan 22, 2019 1:01 PM (in response to Peter Fakan)Hi Peter,
The Rank Investigation calculated field under measures is what I want to fix. It's ranking it as desc when I want it to rank as asc.
Barb

4. Re: Rank calculation
Barb Reiser Jan 22, 2019 1:04 PM (in response to Deepak Rai)Hi Deepak,
Yes, that matches what I did when I pulled the measure over and used the quick table calculation, see my original screen shot. However, I want a calculated field to apply the rank as asc and not use the quick table calculation option.
Barb


6. Re: Rank calculation
Barb Reiser Jan 22, 2019 2:10 PM (in response to Peter Fakan)It doesn't look like Deepak used a calculated field. It looks like he dragged the measure over and used the quick table calculation. I need a calculated field, not a quick table calculation.
Using the sort option doesn't change the numbers for me.
This is how it's ranking now using the calculated field:
This is how I want it to look:

7. Re: Rank calculation
Peter Fakan Jan 22, 2019 3:36 PM (in response to Barb Reiser)
Rank workbook_v10.2.twbx 70.6 KB


8. Re: Rank calculation
Barb Reiser Jan 22, 2019 3:45 PM (in response to Peter Fakan)What calculated field are you using? I only see that you dragged the measure over and used the quick table calculation which is not what I'm looking for.

9. Re: Rank calculation
Barb Reiser Jan 22, 2019 3:53 PM (in response to Barb Reiser)I realized what I did wrong. In my calculation I was using a capital ASC and I needed to use lower case asc. The formula now works with the lower case asc.