Translation of data to one "Coefficient"?

Question

SQL

Hello.

I wanted to know whoever applied in practice the translation of many numerical knowledge to one.
For analytics in SQL.

There are different values, for example:
125
12.5
125.12
1.125
123546
etc.

The idea is to convert the data into a coefficient and then work with them.
There is a lot of data and I want to somehow convert everything to a single value.
Can anyone come across, and is it worth it in general to do this?