Divide a column by a number?


I have a column (it’s a distance, in meters). I would like to display it in miles instead. I can’t seem to figure out a way to apply a formula to every value of the current column. I just want to do: VAL / 1609.34. Is this possible?

Thank you


Perform the calculation in a second column.

[Column 2] = [Column 1] / 1609.34

Ok thanks… I was hoping I could do it in place :slight_smile:

1 Like

I believe if you “did it in place” it would be recursive and throw an error. Formulas are about transforming values. You can’t apply a formula to itself because it would be transforming itself as it computed, which is a problem.


1 Like