We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Adding Decimals to a Field

Jmacnevin
6 - Meteoroid

Hello,

 

I'm using a data set that contains a field for dollar values, however there are no decimal spaces.  For example:

AMT

1050

896

469

 

I want to modify those fields to the following by adding a decimal;
AMT

10.50

8.96

4.69.

 

Can someone assist with a formula (assuming I would use the formula tool) to solve this issue?

 

Thanks!

2 REPLIES 2
lwolfie
10 - Fireball

Could you use the formula tool and just divide by 100?  [AMT]/100 with the data type set to double.

Jmacnevin
6 - Meteoroid

Yes, that did work.  Thanks!

Labels