Is there an alternative way to:
- Add "$" prefix to the product of (SHIPPING FEE * USD CONVERTION RATE)
- ROUND UP (SHIPPING FEE * USD CONVERTION RATE) to the nearest 10 dollars or nearest 100 dollars
What I did:
- Created a custom setting where I entered the USD CONVERTION RATE (1.3333).
- Created a formula field called USD SHIPPING FEE. The formula is:
*CEILING($Setup.Custom_Exchange_Rate * Shipping Fee)*
The compile size is 338 characters but I can't save it because of the error.
Note that SHIPPING FEE is just a currency field where users manually enter the value.