New to Kendo UI for jQuery? Download free 30-day trial

Display Mixed Currencies in Grid


Product Progress Kendo UI Grid
Made with version 2017.1.223


I have a global sales application in which the sales staff work on accounts around the globe. They need to see the currency in the culture format of their countries in the same Grid. For example, User 1, $1,000.00, User 2, €2.000,00, User 3, £50.000.000,00.

How can I display different currencies in the same Grid?


Use a custom approach by utilizing the column.template property of the Grid. This logic requires information about which the correct currency for each displayed data item is and you need to use a manual format for every currency.

<div id="example">
      <div id="grid"></div>
        $(document).ready(function() {
            dataSource: {
              type: "odata",
              transport: {
                read: ""
              schema: {
                model: {
                  fields: {
                    OrderID: { type: "number" },
                    Freight: { type: "number" },
                    ShipName: { type: "string" },
                    OrderDate: { type: "date" },
                    ShipCity: { type: "string" }
              pageSize: 20,
              serverPaging: true,
              serverFiltering: true,
              serverSorting: true
            height: 550,
            filterable: true,
            sortable: true,
            pageable: true,
            columns: [{
              filterable: false
                      {field:"Freight", template:"#= currency(data)#"},
                        field: "OrderDate",
                        title: "Order Date",
                        format: "{0:MM/dd/yyyy}"
                      }, {
                        field: "ShipName",
                        title: "Ship Name"
                      }, {
                        field: "ShipCity",
                        title: "Ship City"

        function currency(data){
          if(data.Freight > 40 ){
            return kendo.toString(data.Freight, "£###.##")
          return kendo.toString(data.Freight, "$###.##")
In this article
Not finding the help you need? Improve this article