Question for all you textmode wizards (David, Doug, Tony, Jason...) I have a text-format calculated field that is performing a CONCAT to join some text with a sum. I want the sum formatted as currency with $ and , at the thousands place, and cents after a decmial. I know in views we can use valueformat=currencyStringCurrency. I'm looking for this functionality in a calculated field. Here's what didn't work for formatting the number as currency: TEXT(SUM(Freelancer Agreed Cost,2000),"$ #,##0.00_") where $ is the HTML code for "$". On it's own the TEXT formula also resulted in a blank value: TEXT(2000,"$ #,##0.00_"). So, my guess is that TEXT() is not supported as is not mentioned in"https://support.workfront.com/hc/en-us/articles/217196767-Understanding-Calculated-Data-Expressions" this help article ,. But maybe there's another way? This version works but does not format the sum with a comma in the thousands place and cents after a decimal. CONCAT("Total VO Cost: $",SUM(Freelancer Agreed Cost,2000)) P.S. This is a nice-to-have item, not a necessity. I am curious if numbers can be formatted in calculated fields. Cory Anderson Cisco Systems- Communication Services
