[Solved] MVC Grid Footer

[Simon]

Hi,

I am using the telerik MVC grid as follows:

......

columns.Bound(o => o.Charge)

.Aggregate(aggregates => aggregates.Sum())

.Width(115)

.Title(

 

"Charge")

 

.ClientTemplate(

 

"<#= FormattedCharge #>")

 

.ClientFooterTemplate(

 

"£ <#= $.telerik.formatString('{0:N}', Sum) #>")

 

.HeaderHtmlAttributes(

 

new { title = "Represents the total........" });

When I do this the total I get in the footer comes up, for example, as £ 16 or £ 2.99999999998. We would expect it to come out as £ 16.00 or £ 2.99. The type of "Charge" above is double.

Could you confirm that the syntax above is correct? If not, could you please provide the correct syntax.

Many thanks

 

[Dadv]

Hi,

try : {0:N2} 

ref : http://msdn.microsoft.com/en-us/library/dwhawy9k.aspx 

Regards,

[Simon]

Thanks - we have tried N2 (and C2) and practically every other combination but without success.

Is this a bug with telerik?

[Dadv]

Perhaps the $.telerik.formatString don't take the round number.. you could probably use javascript instead :

Math.round(number).toFixed(2)

something like that : "£ <#= Math.round($.telerik.formatString('{0:N}', Sum)).toFixed(2) #>"

but i'm not really sure that telerik will  use it like a javascript function...

I'll do some test this afternoon