Divide a column by a number?

1

Hi…

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
Dan

2

@Dan_Tulovsky

Perform the calculation in a second column.

[Column 2] = [Column 1] / 1609.34

3

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

1 Like
4

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.

Lloyd

1 Like