How to achieve 5 digit decimal precision in Currency type column?

1 Answer 110 Views
Filter Grid
Satish
Top achievements
Rank 1
Satish asked on 09 Jun 2021, 02:07 PM

In my Application there is column of Currency type. Ex: If there is some value $230.344 coming from database it is displaying as $230.34. When I am entering 230.34 in is equal to filter, it is not filtering this value. No value is displayed. 

How can I filter the displayed value in currency column

1 Answer, 1 is accepted

Sort by
0
Georgi Denchev
Telerik team
answered on 14 Jun 2021, 08:23 AM

Hi, Satish,

You can change the display format of the column through the columns.format configuration:

{
    field: "Price",
    format: "{0:c4}" // 4 symbols after decimal point
}

Example in dojo: https://dojo.telerik.com/@gdenchev/oviNEvif 

Filtering by 3.1415 seems to work properly. Make sure the value in the dataSource is indeed 230.344 and it's not rounded to 2 digits.

Best Regards,
Georgi Denchev
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Tags
Filter Grid
Asked by
Satish
Top achievements
Rank 1
Answers by
Georgi Denchev
Telerik team
Share this question
or