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