Grand Total Line Calculation

[Benson]

Support,

My report look like this:

           amt1         amt2         percentage (amt2-amt1)/amt1*100%
-----------------------------------------------
           100           150                 50
           200           400               100
----------------------------------------------
total    300            550               83.33

I know how to calculate the total of amt1 (=sum(amt1)), total of amt2 (=sum(amt2)).
Question:
 1. How to calculate total line "percentage"?

Benson.

[Svetoslav]

Hello Benson,

You can try with this expression:

= ((Sum(amt2) - Sum(amt1)) / Sum(amt1)) * 100

If you wish to have the result formatted in percentage (%) you can set the TextBox.Format to {0:P2}.

The upcoming Q2 version will provide both format and expression builders that will make the tasks on formatting and writing expression easier.
 

Sincerely yours,
Svetoslav
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center