Currency item appears in number format, not currency

  • 1
  • Question
  • Updated 2 months ago
  • Answered
how do you make the total price value appear as a number e.g. containing commas. So the number above should read £671,502.29 . The field is a sum of the TotalPrice on opportunity line items
Photo of Glenn Daly

Glenn Daly

  • 1,250 Points 1k badge 2x thumb

Posted 8 months ago

  • 1
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Are you summing the opportunity amounts in JS?   If you can use the currency field renderer you should get commas.  Otherwise if you are just injecting a field value - you may need to parse the number and add commas. 

If you use an aggregate model you can simply use field merge syntax - that will correct include the currency renderer. 
Photo of Kaede Holland

Kaede Holland

  • 2,744 Points 2k badge 2x thumb
Can you elaborate on this, Rob? I'm using an aggregate model and a UI only formula field to display a currency value in a rich text component - and (luckily) we need some commas. 
Photo of Kaede Holland

Kaede Holland

  • 2,744 Points 2k badge 2x thumb
Figured it out. formula output as a number value. triple curly brackets in the UI only formula field, double curly brackets in the rich text component. :)
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Way to go...