Get a count of a unique entry

[#1]

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!

[CELAMBARASAN]

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

[mphekin12 · Accepted solution]

Try this:

if(((CALLER= 'INS') AND (PRIMARY_CALL_REASON= 'INFORMATION') AND (SECONDARY_CALL_REASON='SCHEDULED ITEMS')),1,0)