Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2006

    Unanswered: Formula for a Rolling Scale 1-5 Help

    I'm trying to get I think its 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

    3Month_0to5Rank: [3MonthRank]/([TotalRecords]-1)*5

    Thanks again
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts