Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
try like
Sum({<Date={'>=$(=Date(Max(Date)))<=$(=(Date(Max(Date)))'},ConvDuration={'>0'}>} 1)
Regards
the sum(1) might be the problem, try sth like
SET vVariable = '=Count({<ConvDuration={">0"}, Date={">=$(=Date(Max(Date)))<=$(=(Date(Max(Date)))"}>} CallID))';
Hi Max,
I think in your code there is mistake happen can you check it once.
Ramya.