how can I apply format 0:c to a grid footer template

[Evgeny Vdovin]

HI 

How can I apply format 0:c to a footertemplate in the Grid.
In one of your example you have avg like this Average: 10.12987012987013 and I think it will be better to present like Average: 10.13

Regards,
Evgeny Vdovin
  

[Gergo]

Hi Evgeny,

You can use the kendo.toString() method to format the footerTemplate,
Please see this example below:

$("#grid").kendoGrid({

           dataSource: {

               data: [

                   {

                       OrderId: 1,

                       NrOfProducts: 2,

                       Price: 155.9987

                   },

                   {

                       OrderId: 2,

                       NrOfProducts: 12,

                       Price: 987.44587

                   },

                   {

                       OrderId: 3,

                       NrOfProducts: 22,

                       Price: 0.7878

                   }

                   ],

 

               aggregate: [

               { field: "NrOfProducts", aggregate: "sum" },

               { field: "Price", aggregate: "sum"}]

           },

           sortable: true,

           scrollable: false,

           columns: [{

               field: "OrderId",

               title: "ID of the Order"

           },

           {     field: "NrOfProducts",

               title: "Number Of Products",

               footerTemplate: "Total Products : #= kendo.toString(sum, '0.00') #"

           },

           {    field: "Price",

               title: "Price",

               footerTemplate: "Total Price: #= kendo.toString(sum, 'C') #"

            }]

       });

Kind Regards,
Gergő

[Evgeny Vdovin]

Thanks a lot

Regards,
Evgeny Vdovin

[Dr.YSG]

And if I want to do that for this bit of HTML (I am running out of quote options)?

01.data-columns='[
02.    "Class",
03.    "Type",
04.     {field: "FileCount",
05.     format: "{0:n2} MB",
06.     aggregates: ["sum"],
07.     footerTemplate: "Total: #=data.FileCount? data.FileCount.sum : 0 #"
08.    },
09.    {field: "Size",
10.     format: "{0:n2} MB",
11.     aggregates: ["sum"],
12.     footerTemplate: "Total: #=data.Size?data.Size.sum : 0 # MB"
13.    },
14.    {field: "Date",
15.     format: "{0:F}" },
16.    "Path",
17.    {command: "destroy"},
18.]'>

[Alexander Valchev]

Hello Dr.YSG,

You can use backslash to escape quotation marks:

"Total: #= kendo.toString(data.FileCount ? data.FileCount.sum : 0, \"n2\") # MB"

Regards,
Alexander Valchev
Telerik

[Philip]

I'm using KendoUI 2014.1.528

I'm trying to format a footer as well using this:

footerTemplate: "#= kendo.tostring(average, \"n2\") #"

I get "JavaScript runtime error: Object doesn't support property or method 'tostring'"

Am I doing something wrong?

[Reqs]

bsimms, try toString instead of tostring?