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 it will be suitable for the Quantity fields.
For the decimal fields, use the below formula
Case when {amount} IS NULL THEN ‘0’ WHEN ({amount} like ‘%.%’ and substr({amount},-2,2) < 1) then {amount}||’0′ when ({amount} like ‘%.%’ and substr({amount},-2,2) >= 1) then to_char({amount}) else {amount}||’.00′ end