Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
How to add a currency symbol in saved search and preserving decimal places?
Hi There
I have the following scenario:
I have a saved search showing customer transaction amounts
I am trying to concatenate the "$" symbol by using formula(text) as the field type
however, doing so results in the trailing zeros dropping off despite a round formula being used:
How do I format the saved search results so that the currency symbol is appended to the front of the amount and the decimal places are preserved?
thanks
0