Skip to Content
0
Former Member
Sep 13, 2013 at 05:52 AM

Formula Help

19 Views

Hi

I am having a reporting requirement and help would be appreciated.

Sample Data

COMPANY Ticket Load Date Ticket Date No of days No of tickets
SLA MET Sydney 100201 02/09/2013 04/09/2013 2 1 1 Melbourne 100202 24/08/2013

25/09/2013

1

1 1 Sydney 100203 05/09/2013 09/09/2013 4 1 1 Melbourne 100204 07/09/2013 10/09/20133
1 1 Melbourne 100205

09/09/2013

15/09/2013

6

1 0


Total
5 1

The Formula to Calculate the SLA is if the No of days <= 4 Days then it met SLA

The desired output is

Company No Of tickets Met SLA Sydney 2 2 Melbourne 3 2

The Calculation to get the SLA is based on the detail data but the output I want to show the aggregated values.

Appreciate if you can provide the formula that would help to achieve this.