Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I really need your expertise.
I'm thinking to create a variable for Talk + Hold.
vTalkHold = num(((sum([Aggr tTalkComplete]))/1000)+(((sum([Aggr tHeld]))/1000)),vFormatSeconds2)
then I will do the below expression in sheets.
sum(if([vTalkHold]>600,1,0))
But I do not have a variable panel access so I have to directly have this measure in master Item.
Please advise
Are you getting something when we use this
If(vTalkHold > 600, 1, 0)
OR
If($(vTalkHold) > 600, 1, 0)