I'm trying to get I think it’s called a rolling scale.
I have 500 records but I would like the rolling scale to rate them from 1-5 with 1 being the best.
The formula I thought would work was "3Month_0to5Rank: [3MonthRank]/([Past_3_Month#]-1)*5" but turns out if keeps going after 5 or I tried switching the formula it gives me more weird numbers.
I really appreciate you taking the time for assist me with this problem.
The formula below worked for a different query but now it is giving me from 0.00125 to 1253.21500