SLA development

[jagadesh]

Hello Everyone,

Actually i'm creating one sla for service inisight. in set expression getting error like Error in expression : ')' expected but i have checked all areas if i missed any paranthesis but unable to found any issue. can any one help me on this. please find the below expression.

(num(count({<State-={'Closed Abandoned'},Type={'Chat'},wait_time ={'=30.00'}>}[number])/count({<State-={'Closed Abandoned'},Type={'Chat'}>}[number]),'#.##%')
+ num(sum([MonthFlag]={'Current Month'},
[Answered In SLA])/(sum({<[MonthFlag]={'Current Month'}>}[Calls Offered])-sum({<[MonthFlag]={'Current Month'}>}[Abandoned In SLA])), '#.##%')
)/2

[Qrishna · Accepted solution]

This should work

= (num(count({<State-={'Closed Abandoned'}, Type={'Chat'},wait_time ={'=30.00'}>}[number])/count({<State-={'Closed Abandoned'},Type={'Chat'}>}[number]),'#.##%') +
num(sum({<[MonthFlag]={'Current Month'}>}[Answered In SLA]) / (sum({<[MonthFlag]={'Current Month'}>}[Calls Offered]) - sum({<[MonthFlag]={'Current Month'}>}[Abandoned In SLA])), '#.##%')
)/2

You dont need nums twice. once is fine.like below: 

= num(((count({<State-={'Closed Abandoned'}, Type={'Chat'},wait_time ={'=30.00'}>}[number])/count({<State-={'Closed Abandoned'},Type={'Chat'}>}[number])) +
(sum({<[MonthFlag]={'Current Month'}>}[Answered In SLA]) / (sum({<[MonthFlag]={'Current Month'}>}[Calls Offered]) - sum({<[MonthFlag]={'Current Month'}>}[Abandoned In SLA]))))/2, '#.##%')

[jagadesh]

Thanks it is working fine

[Qrishna · Accepted solution]

Please close the thread by marking my reply as answer so oher people in need can find it more easily. thnx