Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Can I make a calculated field that has a custom currency field and custom text fields?

Avatar

Level 4

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,

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 4

For anyone that finds this in their search. I learned today that this is NOT possible. The result needs to be text and therefore the field you are pulling in would also need to be text you cannot pull the special character "$" into this calculated field.

View solution in original post

2 Replies

Avatar

Correct answer by
Level 4

For anyone that finds this in their search. I learned today that this is NOT possible. The result needs to be text and therefore the field you are pulling in would also need to be text you cannot pull the special character "$" into this calculated field.

Avatar

Administrator

Hi Dawnmarie,

I love that you came back and let the community know what you found out. I know that took an extra step for you to share, but hopefully it saves someone in the future an extra step.

Thank you for being a wonderful part of our Workfront community.

Kyna Baker