Monday, February 25, 2019

Remove Comma on Saved Search Results for any Currency or Numeric Field

On a saved search where a currency field is added. The results will show the currency amount separated by comma by the thousand.

Users may remove the comma separator by using the following result formula field:

1. Create a Saved Transaction Search, List > Search > Saved Searches > New > Transaction.

2. On the results tab, add the following:

3. Add Formula (Text)
Formula: trim(both ',' from {totalamount})

Note:  Replace {totalamount} with the currency field that you wish to remove the comma separator.

No comments:

Post a Comment