AnsweredAssumed Answered

Currency format in calculated field

Question asked by Francisco Ortega on Apr 23, 2015
Latest reply on Apr 24, 2015 by Francisco Ortega
Sugar Professional, Versión 7.5.1.0

Hello:



I created a text calculate fiel and used a concat formula:
          
        concat("$",ceil(currencySubtract($total_month_amount_c,0))," ","Acr.","    |    ","$",ceil(currencySubtract($coa_total_month_amount_c,0))," ","Coa.")


I got it:

     $44000 Acr. | $43000 Coa.


I need the currency format, i.e $44,000.00

I tried all.

Some one?

Thank you.

Outcomes