This is a migrated thread and some comments may be shown as answers.

DataFormatString not working for decimal.

3 Answers 123 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Joe
Top achievements
Rank 2
Joe asked on 11 Dec 2015, 06:31 PM

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}";

3 Answers, 1 is accepted

Sort by
0
Eyup
Telerik team
answered on 16 Dec 2015, 02:35 PM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Joe
Top achievements
Rank 2
answered on 01 Feb 2016, 03:40 PM
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.
0
Eyup
Telerik team
answered on 04 Feb 2016, 11:28 AM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
PivotGrid
Asked by
Joe
Top achievements
Rank 2
Answers by
Eyup
Telerik team
Joe
Top achievements
Rank 2
Share this question
or