Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to a get a unique count of wheneven the Caller=INS and Primary Call Reason= Information AND Secondary Call Reason = Scheduled Items, then return 1 otherwise zero.
This is the If statement I am using:
IF(((CALLER= 'INS') AND (PRIMARY_CALL_REASON= 'INFORMATION')AND (SECONDARY_CALL_REASON='SCHEDULED ITEMS'))1,0)
This is not working for me for some reason.
Please help!
Thanks!
Try this:
if(((CALLER= 'INS') AND (PRIMARY_CALL_REASON= 'INFORMATION') AND (SECONDARY_CALL_REASON='SCHEDULED ITEMS')),1,0)
Hi,
Try this
Count({<CALLER={'INS'},PRIMARY_CALL_REASON={'INFORMATION'},SECONDARY_CALL_REASON={'SCHEDULED ITEMS'}>} Distinct FieldName)
Mostly it will work in your case.
If it is not your requirement then provide little more information like where you are using this expression?dimensions and expressions?
Celambarasan
Try this:
if(((CALLER= 'INS') AND (PRIMARY_CALL_REASON= 'INFORMATION') AND (SECONDARY_CALL_REASON='SCHEDULED ITEMS')),1,0)