Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Nate MeginnesNate Meginnes 

Can I display Amount field on Opportunity page, formatted with dollar sign?

Hi! What I'm trying to do is pretty simple, but I'm not sure how to achieve it. On our Opportunity page, I'd like to show "Amount" in 2 places. I made a Formula field to pull the information from Amount using TEXT(Amount). I'm now seeing the number in both places, but it is displayed in the Amount field as "$824.00" and under the new field as "824". Is there anyway to pull this information into a new field and retain the currency format?
Best Answer chosen by Nate Meginnes
Shravan Kumar 71Shravan Kumar 71
Hi Nate,

In the forumla just use Amount field (remove TEXT function) and the formula retrun type should be Currency. 

Let me know if this works.

Thanks,
Shravan

All Answers

Shravan Kumar 71Shravan Kumar 71
Hi Nate,

In the forumla just use Amount field (remove TEXT function) and the formula retrun type should be Currency. 

Let me know if this works.

Thanks,
Shravan
This was selected as the best answer
Nate MeginnesNate Meginnes
Thank you! Of course it's just that simple.