Mitel Forums - The Unofficial Source
Mitel Forums => Mitel Software Applications => Topic started by: PuntsWorth on July 31, 2012, 09:58:18 AM
-
Hi,
Does anyone know how to add rows to give a total.
I have tried the expression
=Fields!EmpGrpByEmpOutCount.ValueFields!EmpGrpByEmpExternalACDCount.ValueFields!EmpGrpByEmpInternalNonACDCount.Value
but doesn't work ???
-
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 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
-
Hi PuntsWorth,
Thank you for the clarification. What you are attempting to do if definitely achievable. Attached to this post is an image with the right expression to use.
If you have any questions, please reply to this thread!
Cheers,
Kevin Middlemiss
prairieFyre Software Inc.
-
Hi PuntsWorth,
Thank you for the clarification. What you are attempting to do if definitely achievable. Attached to this post is an image with the right expression to use.
If you have any questions, please reply to this thread!
Cheers,
Kevin Middlemiss
prairieFyre Software Inc.
Hi Kevin,
That worked 100% :) however the totals are incorrect.
the expression I am using is
=(Fields!EmpGrpByEmpExternalOut.Value+Fields!EmpGrpByEmpExternalACDCount.Value+Fields!EmpGrpByEmpExternalNonACDCount.Value)
External External External Total
outbound ACD count Non ACD
count Count
5 3 0 8
7 3 0 11
8 3 0 11
22 2 1 24
14 2 0 16
5 2 0 7
16 2 0 18
20 1 0 22
0 0 0 1
10 1 2 14
3 1 0 4
0 0 0 0
15 0 0 16
0 0 0 4
8 0 0 8
8 0 0 10
-
Im no expert on flexible reporting but at a guess from your results i would say there is some rounding up/down going on for some reason.
In Excel there are ways of using whole integers only, maybe this will set you in the right direction.