I have a report, where one of the values had a value that had a 1 to 100 range. My manager wants a different calculation. I have to take that initial value and multiply it by two other values and now that number could be 375. How can I keep the ratio 1-100 ....If the maximum value is now 475, how can I show that on a scale of 1 to 100...
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to display a value in a 1 to 100 range, if the Max value is 475...
- Thread starter Pack10
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question
