excluded formula in set analysis

[Anonymous]

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,

[rubenmarin]

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')