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
