Sum if

[#1]

Hello Guys,

I am having an issue with a variable which I am creating:

=Sum({<Date={'>=$(=Date(Max(Date)))<=$(=(Date(Max(Date)))'}>}if(ConvDuration>0,1,0))

Actually I need to get the total call of today whereby the conversation duration exceeded 0 seconds.

Thanks for your usual help.

Kind Regards,

Hasvine

[PrashantSangle]

Hi,

try like

Sum({<Date={'>=$(=Date(Max(Date)))<=$(=(Date(Max(Date)))'},ConvDuration={'>0'}>} 1)

Regards

[danieloberbilli]

the sum(1) might be the problem, try sth like

SET vVariable = '=Count({<ConvDuration={">0"}, Date={">=$(=Date(Max(Date)))<=$(=(Date(Max(Date)))"}>} CallID))';

[#4]

Hi Max,

I think in your code there is mistake happen can you check it once.

Ramya.