Format currencies

Page 1 of 1
4 posts
Format currencies

kmhil
New MMEX User

Posts: 2
Joined: Fri May 20, 2016 11:14 am
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
Attachments
Scotiabank Visa.grm
(1.68 KiB) Downloaded 97 times
Re: Format currencies

Nikolay
MMEX Developer

Posts: 2298
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
Re: Format currencies

Nikolay
MMEX Developer

Posts: 2298
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
Use JS for formating. In the sample  file the code from line 
<!-- Format numbers -->
Re: Format currencies

kmhil
New MMEX User

Posts: 2
Joined: Fri May 20, 2016 11:14 am
Not really good with JavaScript but I found a way to format it from SQL.

Thank you very much!
Page 1 of 1
Who is online

Users browsing this forum: No registered users and 2 guests

cron