Remove Comma from the text field in Saved Searches

The formula to remove the commas (for 1000 separation) in the amount/currency type fields can not be applied for text fields.

For the text fields, the replace function can be used to remove the comma.

REPLACE({amount},’,’, ”)

Leave a comment

Your email address will not be published. Required fields are marked *