I am having a reporting requirement and help would be appreciated.
Sample DataCOMPANY Ticket Load Date Ticket Date No of days No of tickets
11 1 Sydney 100203 05/09/2013 09/09/2013 4 1 1 Melbourne 100204 07/09/2013 10/09/20133
The Formula to Calculate the SLA is if the No of days <= 4 Days then it met SLA
The desired output isCompany 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.