Replace Empty Cells With Zeros

5 posts, 1 answers
  1. Ahmad
    Ahmad avatar
    3 posts
    Member since:
    Jan 2014

    Posted 14 May 2014 Link to this post

    Hello.
    Is there any way to replace the empty cells from the PivotGrid with zeros?.
    the attached picture is an example of my PivotGrid I want to replace those empty cells with zeros.
    Please Help me.
  2. Answer
    Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    641 posts

    Posted 14 May 2014 Link to this post

    Hello Ahmad,

    RadPivotGrid has EmptyValueText which you can set to "0". You can also use ErrorValueText in order to set 0 if an error happened while calculating the cell (for example divide by zero).

    <pivot:RadPivotGrid  x:Name="radPivotGrid" DataProvider="{StaticResource DataProvider}" EmptyValueText="0" ErrorValueText="0"/>

    Hope this helps.

    Regards,
    Rosen Vladimirov
    Telerik
     
    Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
     
  3. Ahmad
    Ahmad avatar
    3 posts
    Member since:
    Jan 2014

    Posted 14 May 2014 in reply to Rosen Vladimirov Link to this post

    Thank you very much you saved my life.
  4. Zack
    Zack avatar
    7 posts
    Member since:
    Dec 2017

    Posted 19 Mar 2019 Link to this post

    Is there a way to do the opposite - to not show a zero for values that are null?   In our case, we set some values and not others and it ends up with half of the cells with zeros and the other half blank. Very jagged and confusing.
  5. Martin Ivanov
    Admin
    Martin Ivanov avatar
    2420 posts

    Posted 22 Mar 2019 Link to this post

    Hi Zack,

    You can try the Group Filtering feature and see if it helps.

    Regards,
    Martin Ivanov
    Progress Telerik
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Back to Top