DataFormatString not working for decimal.

[Joe]

Hello, I have a pivot grid with an aggregate field that holds an average of percentages in the form of 100.0000 etc.

 I get numbers like 99.90356798455882352941176471

 I've tried "{0:P}", "{0}N %" but nothing works. What can I do? Is it a bug? It's a telerik version from 2013.

PivotGridAggregateField aggregateField = new PivotGridAggregateField();
RadPivotGrid1.Fields.Add(aggregateField);
aggregateField.DataField = "PercentOD";
aggregateField.UniqueName = "PercentOD";
aggregateField.Aggregate = PivotGridAggregate.Average;
aggregateField.DataFormatString = "{0:F2}";
aggregateField.TotalFormatString = "{0:F2}";

[Eyup]

Hi Joe,

Version from 2013 is quite back beyond. Could you try this with a recent version and see what would be the result?

Regards,
Eyup
Telerik

[Joe]

I was locked to an older version with DotNetNuke though I think I can upgrade that... I do have the latest so I may give try and upgrade what is in DNN.

[Eyup]

Hello Joe,

You probably already know that, but I want to remind that DNN is no longer supported. If the configuration of the controls work in a separate isolated web site, you can take your questions to DNN team:
https://admin.telerik.com/www.dnnsoftware.com/forums

Regards,
Eyup
Telerik