Hi PuntsWorth,
Sorry for the delay in my response. Can you provide a bit more details of what exactly you want to do? For example, this is what I would do to add a column in Flexible Reporting to do the sum of certain fields;
1. Launch Flexible Reporting and either create, modify a report.
2. Choose all the report/device types necessary.
3. Once you are in the report builder, right click on the last column and choose Insert Column > Custom. A blank Column will appear.
4. In the bottom field, right click then choose "Expression". The Expression builder will appear.
5. In the expression builder, you will have many options (Fields, Functions, Operators) to choose from to build the right expression for the report you are tailoring.
6. For example: If I want to have the sum of EmployeeGroupByAgentACDCount, EmployeeGroupByAgentNonACDCount and EmployeeGroupByAgentOutCount, here's what to do;
- In the Expression field, start by putting the "=" sign.
- Click on Functions > Aggregate then double-click on Sum. You will see =Sum( appear in the Expression field.
- Click on Fields > Employee Group > double-click on EmployeeGroupByAgentACDCount.
- Click on Operators > Arithmetic > double-click on "+"
- Click on Fields > Employee Group > double-click on EmployeeGroupByAgentNonACDCount.
- Click on Operators > Arithmetic > double-click on "+"
- Click on Fields > Employee Group > double-click on EmployeeGroupByAgentOutCount.
- Close the expression with a bracket ")"
- Click Ok - Then you can test by using
That is one example, but you can easily see how simple and flexible the expression builder truly is.
If you need more information, feel free to PM me or continue posting on this thread.
Kind regards,
Kevin Middlemiss
prairieFyre Software inc.
Hi Kevin,
Cheers for the info, it worked but didn't give me the outcome I needed, as I don't think I have explained what I wanted correctly.
We need to add across the rows, for example;
Agent ACD Calls Non ACD Calls Total
Jon 5 5 10
Garry 20 3 23
Sarah 0 2 2
On your guide, it seems to count on the columns.
Is the above possible?
just to let you know, I used the following;
=Sum(Fields!EmpGrpByEmpExternalOut.Value+Fields!EmpGrpByEmpExternalACDCount.Value+Fields!EmpGrpByEmpInternalNonACDCount.Value)Cheers