How to SUM the results of a column.

[Balen]

HI Guys,

 

I am new to telerik report designer, i have trying to create a report that consists of 3 sections.

Section 1 is a summary of a team, section 2 is the average of staff, and staff stats.

I am having difficulty with the average row as i need to sum the values of each agents "Calls to Success" stats and divided by the number of agent which is 3.

So i should be getting 5.14.

 

Any idea guys.

 

Thanks

 

 

[Neli]

Hello Balen,

You can use the approach applied in the attached report:

1. Add a CSV DataSource with Name and CallToSuccess columns;

2. Display the data in a Table item;

3. Right-click over the table -> Insert row - > Outside group - Below

4. In the new row, use the Aggregate function AVG:

= Avg(Fields.CallsToSuccess)

Because you mentioned that you are new to Telerik Repoting, I am sending you our First steps articles that demonstrate how to create, set up, and publish a sample Demo report.

- Creating the Demo report

- Setting the page header

- Populating the table with data

- Creating the graph

- Setting the page footer

- Integrating the report in Visual Studio Application

- Parameterizing the graph

- Adding the column graph

 

Regards,
Neli
Progress Telerik

[Augusto]

Excelent!! it works for me... thanks a lot!