Calculations on some columns

2 posts, 0 answers
  1. David
    David avatar
    1 posts
    Member since:
    Nov 2015

    Posted 03 Nov 2015 Link to this post

    Hi, there! 

    I have a pivot grid with a column field which is Types of budgets, there are 3 in the SQL query: initial budget, real budget, executed value. I want two calculated fields, namely the percentage difference between the initial budget vs real budget and executed value. The result would be something like:

     INIT    REAL  Dif%  EXEC  Dif%

    $1000  $900  -10%  $1100 +10%

     Is there a way to do it with custom calculated fields?

    Thanks a lot!

  2. Viktor Tachev
    Viktor Tachev avatar
    2501 posts

    Posted 05 Nov 2015 Link to this post

    Hi David,

    You can add calculated field and define custom calculations for them. Check out the following article that describes the approach in more detail.

    Viktor Tachev
    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