DataFormatString not working for decimal.

4 posts, 0 answers
  1. Joe
    Joe avatar
    6 posts
    Member since:
    Feb 2015

    Posted 11 Dec 2015 Link to this post

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

  2. Eyup
    Admin
    Eyup avatar
    3005 posts

    Posted 16 Dec 2015 Link to this post

    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
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Joe
    Joe avatar
    6 posts
    Member since:
    Feb 2015

    Posted 01 Feb in reply to Eyup Link to this post

    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.
  5. Eyup
    Admin
    Eyup avatar
    3005 posts

    Posted 04 Feb Link to this post

    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
Back to Top