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
 
					
				
				
			
		
