Page 1 of 1

Format currencies

Posted: Fri May 20, 2016 5:25 pm
by kmhil
Hi guys!

I've modified one of the reports I found on GitHub (CreditReport to be exact) for my needs, but I need some help with formating the results.

At first the results where with all decimals and no prefixes but I kinda hardcode it to show them, but don´t know how to formats decimals and commas.

I got this

S/. -3165.88217599999

And I need something like these

S/. -3,165.88 or S/. -3 165.88

Thanks in advance to anyone who can guide me.

Klausen

Re: Format currencies

Posted: Sun May 22, 2016 7:55 pm
by Nikolay

Re: Format currencies

Posted: Sun May 22, 2016 7:59 pm
by Nikolay
Use JS for formating. In the sample  file the code from line 
<!-- Format numbers -->

Re: Format currencies

Posted: Tue May 24, 2016 10:36 pm
by kmhil
Not really good with JavaScript but I found a way to format it from SQL.

Thank you very much!