Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
anything wrong with my formula? Error Garbage Expression keeps on showing though the % result is correct.
count(aggr(if(Sum([Aggr nOffered])>1,num(Sum([Aggr nOffered]),vFormatSeconds2), null()) ,[Formatted CLI])) / count(distinct{<[Participant Purpose] ={'customer'},[Conversation Direction]= {'inbound'}>} [Formatted CLI])
Please help....
It is not your measure expression
In Master objects you might have dynamic name for your label and that is what is failing.
cheers
Lech
That is the title. Make sure you have the correct title there (Maybe Repeat only):
Hi Fei Xu,
The error is still showing
I see, the title is correct. It is the expression. Can you show me the screenshot for the whole expression?
Can you please show us the full screen like this?
It is not your measure expression
In Master objects you might have dynamic name for your label and that is what is failing.
cheers
Lech
now i see that... Thanks Lech!!!