Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi..
I have two formulas
first formula is:
num(count({<PeripheralCallType = {'2'},AgentSkillTargetID={"*"},TimeToAband ={'>0'}>} distinct ACD_UNIQUECALLS),'#,##0')
seconded formula is:
num(count({<PeripheralCallType = {'1'},TimeToAband ={'>0'}>} distinct ACD_UNIQUECALLS),'#,##0')
now i am trying to excluded second formula from first formula
as
num(count({<PeripheralCallType = {'2'},AgentSkillTargetID={"*"},TimeToAband ={'>0'},acdunicaall=e(only({<PeripheralCallType = {'1'},TimeToAband ={'>0'}>} distinct ACD_UNIQUECALLS))>} distinct ACD_UNIQUECALLS),'#,##0')
but its not working properly..
can you please help me..
Thanks,
Hi Chandini, you can do a substract?:
num(count({<PeripheralCallType = {'2'},AgentSkillTargetID={"*"},TimeToAband ={'>0'}>} distinct ACD_UNIQUECALLS)
- count({<PeripheralCallType = {'1'},TimeToAband ={'>0'}>} distinct ACD_UNIQUECALLS)
,'#,##0')
Anyway, I don't thinh e(only(.. will work, as Only() returns one value and the expression inside returns multiple values, maybe:
num(count({<PeripheralCallType = {'2'},AgentSkillTargetID={"*"},TimeToAband ={'>0'},acdunicaall=e({<PeripheralCallType = {'1'},TimeToAband ={'>0'}>} distinct ACD_UNIQUECALLS)>} distinct ACD_UNIQUECALLS),'#,##0')