Is there a way to calculate a rank based on the value of a field? For example, if the field is Total Sales, I can sort in descending order by this field, but can I create a formula that gives me the rank of each person in another field?

I’m hoping I can get some help around using the Group By functionality. My base has a few number fields and a calculated field (using a formula). For simplicity, let’s say I have fields Name, A, B, C, and D. The formula for D = (A+2B) / C. When I ...