### Title

Help with a formula

### Post

I have 4 records listed in a portal. And each of those records has a field called "Number." As an example, those "Numbers" are 4, 8, 2, 12 (but will be totally random).

I need a formula that would put the lowest number of the four, which in this case is 2, and change it to 0.

Then, take the four and change it to 2, the 8 and change it to 6, and the 12 and change it to 10.

So the original "Number" which was the lowest of the four went from 2 to 0. So the other three numbers need to be reduced by 2 also. Whatever the lowest number happens to be, whatever takes that number to zero, then the other 3 numbers would be subtracted that number.

Does this make sense to anyone besides me? And if so, what would such a formula look like?

A portal indicates that you have a relationship between the layout's table occurrence and the portal's table occurrence. What is that relationship?

Is this a filtered portal?

Do you want to change the values in this actual number field or use a second field to show the modified values, leaving the original values unchanged?