In the amount and quantity field in the saved search results, there will be a comma separation for values that is greater than 1000 (Ex: 2,245). To avoid these commas, we can use the TRIM function. TRIM(‘,’ FROM {amount}) When using the TRIM function, the decimal part will be removed if it is .00. So… Continue reading Remove Comma from the Amount and Quantity fields in the saved search