Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Could you help me to find my mistake please.
=count({<час_минута={'=$(=min(час_минута))'}>} [Call ID]) I have got 0
min - '10:55'
=count({<час_минута={'10:55'}>} [Call ID]) I have got 9298
This one is woking :-). Thanks
=count({<час_минута={'=[час_минута]=min(TOTAL час_минута)'}>} [Call ID])
Hi!
Min() function return Numeric type of data. Try to convert it to required format again? like:
=count({<час_минута={"=$(=time(min(час_минута),'hh:mm'))"}>} [Call ID])
or
=count({<час_минута={"=$(=text(time(min(час_минута),'hh:mm')))"}>} [Call ID])
or not use dollar sign
=count({<час_минута={'=min(TOTAL час_минута)'}>} [Call ID])
or use boolean expression
=count({<час_минута={'=[час_минута]=min(TOTAL час_минута)'}>} [Call ID])
And check [час_минута] field is numeric.
If the value is a string in час_минута,
=count({<час_минута={'=$(=MinString(час_минута))'}>} [Call ID])
This one is woking :-). Thanks
=count({<час_минута={'=[час_минута]=min(TOTAL час_минута)'}>} [Call ID])