Help please, Transform value in place by dividing by 1000 (without a new column)

[I_Like_Pi]

Is there any way to leverage the transform column function to apply a math operation to the feild in place. I.E. not a new column  then delete the orginal then rename the new column as the old.

I have an order form coming in with line numbers that the system treats as a 3 digit line with 3 digits of sub line 001.000.  but it really only stores it as 1000. 

I feel like transform should be able to apply an operation to a column but just cant find the right way to do it.

[I_Like_Pi]

I can't post company data, but pick any column with number values, ie some systems store pennies with no decimals. I would like to convert to dollars without adding a column.  

Amount

12345

654321

200

300

should be

Amount

123.45

6543.21

2.00

3.00

[serpiva64 · Accepted solution]

Hi, 

in trasform use Standard - multiply

then

then you obtain the formatting on the canvas

If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !

[I_Like_Pi]

Wow! I knew it was obvious. Just couldn't see what was right in front of me.

Thanks!

[serpiva64]

Hi,

some sampple data should help resolving the issue