9 Replies Latest reply on Jan 22, 2019 3:53 PM by Barb Reiser

    Rank calculation

    Barb Reiser

      Anyone know why the rank calculated field won't rank by asc? Is my formula wrong? You see in my screen shot it has the highest value ranked as 1. If I add the actual measure and choose Rank in the quick table calculation and then adjust it to Ascending, that works so I get the 6, but I need the calculated field to work. Any ideas? I've attached the workbook.