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


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.