Hi all, I need help in formatting the data in Alteryx. I have attached the input and desired file below for your reference. Please see the comma and decimal points. Please help, its urgent!!!
Amounts | Desired output |
1.513.72 | 1513.72 |
1,513.00 | 1513 |
1513.388889 | 1513.39 |
1,513,23 | 1513.23 |
13,00 | 13 |
42.788.04 | 42788.04 |
1,1513.3888888881 | 11513.39 |
1.1513.3888888881 | 11513.39 |
4.8 | 4.8 |
8 | 8 |
18 | 18 |
169,12 | 16912 |
Hi @Noshi ,
Try using a round function and see if that works for you. I have attached an example below
Hope that helps,
Angelos