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