SUM Aggregate Function not Working Correctly in Telerik Report Designer

[Muhammad Mohsin]

Hi, 
I was designing a report and had multiple columns inside a table, e.g;

Column-A  || Column-B
String 1      ||       45000

String 2      ||

String 3      ||       2000

 

Now, clearly as you can clearly see, on column-B we are supposed to perform SUM function. And this column contains one empty field. Also, I would like to mention here that table is being populated using "expression" and I am supposed to show sum of this column in separate textbox. 

What I am already doing is; " =SUM(Fields.amount)" but that is not giving me correct answer.

I shall be thankful for any help. 

Regards,
Muhammad Mohsin

[Yana]

Hi Muhammad,

In general, the expressions are evaluated in the current scope. In order to show the sum of a certain column, you will need the data scope of the whole report or a parent group - this could be achieved with the Exec data function like this:

=Exec('Report1',Sum(Fields.amount))

Hope this helps.

Regards,
Yana
Progress Telerik

[Muhammad Mohsin]

Bundle of thanks, it worked perfectly.