set analysis without variable panel

[Anonymous]

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

[shraddha_g]

Try,

sum(

if(

num(((sum([Aggr tTalkComplete]))/1000)+(((sum([Aggr tHeld]))/1000)),vFormatSeconds2) >600 ,1,0

)

)

[Anonymous]

it says "error in expression"

[Anonymous]

I have also tried this but still shows "error in expression"

sum(if(num(sum([Aggr tTalkComplete])/1000)+(sum([Aggr tHeld])/1000))>600,1,0))

[shraddha_g]

can you share sample app?

[Anonymous]

Talk Hold = sum(([Aggr tTalkComplete])/1000)+(sum([Aggr tHeld])/1000)

beyond 10mins = if((sum([Aggr tTalkComplete])/1000)+(sum([Aggr tHeld])/1000)>600,1,0)

so the problem is this.. the sumbeyond10mins should show 4

Thank you Shraddha!

[shraddha_g]

In 2nd Image showing Date & sumbeyond10mins what you have used?

[shraddha_g]

Sum(if((sum([Aggr tTalkComplete])/1000)+(sum([Aggr tHeld])/1000)>600,1,0))

Should work in 2nd image

[Anonymous]

i just copied the expression of beyond10mins because i also tried this (exactly what you are suggesting) but says

error.

[shraddha_g]

Try using Variables for

sum([Aggr tTalkComplete])/1000

and sum([Aggr tHeld])/1000

and use those variables here