This is a migrated thread and some comments may be shown as answers.

SUM Aggregate Function not Working Correctly in Telerik Report Designer

2 Answers 305 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Muhammad Mohsin
Top achievements
Rank 1
Muhammad Mohsin asked on 24 Jul 2017, 07:32 AM

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

2 Answers, 1 is accepted

Sort by
0
Yana
Telerik team
answered on 27 Jul 2017, 07:52 AM
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
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
0
Muhammad Mohsin
Top achievements
Rank 1
answered on 27 Jul 2017, 09:00 AM
Bundle of thanks, it worked perfectly. 
Tags
General Discussions
Asked by
Muhammad Mohsin
Top achievements
Rank 1
Answers by
Yana
Telerik team
Muhammad Mohsin
Top achievements
Rank 1
Share this question
or