i want to get a currency amount format with two digits decimal values, Please advise me ?
i want to get a currency amount format with two digits decimal values, Please advise me ?
My datatable shows only round values in amount column , i want to have a values with currency format like $233.25 instead of $234.00.
HTML table head code
<thead>
<tr>
<th>Date</th>
<th>SalesNumber</th>
<th>AmountExclGST</th>
<th>GST</th>
<th>TotalAmount</th>
<th>ContactPerson</th>
<th>Status</th>
<th>FullyPaid</th>
<th>Attachment</th>
</tr>
</thead>
javascript code for columns:-
{ 'data': 'AmountExclGST',
'render': $.fn.dataTable.render.number(',', '.', 2, 'S$')
},
My result column :- amount S$234.00 correct format should be Amount S$233.25 Please advise me what should i need to do , in order to get currency format with decimal values ?
This question has an accepted answers - jump to answer
Answers
Sorry i have solved the issue , i had defined as int in webservice .... sorry...