I have tried everything I can think and I have searched and searched and can't find anything related. I've tried it as text, number, currency.
This is my set up now and I can get the correct result but I would like to change my Amount field to a currency field and therefor my result from the calculated field to show as currency.
CONCAT("Name", " - ", Request Type, " - ", "ID#", {Receipt ID #}, " - ", "$", {Amount})
Result: Dawnmarie - Return - ID#123 - $5000
My preferred result would be: Dawnmarie - Return - ID#123 - $5,000.00
Any help would be appreciated. Thank you in advance,