Replace Empty Cells With Zeros

3 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
    640 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. UI for WPF is Visual Studio 2017 Ready
  4. 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.
Back to Top