Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
Could you please help me to get the expression below to work:
=-(1-(sum(total<Friendly_Name,FirstName,LastName>AGGR(
( COUNT( {<FirstAgent={'<>0'}>}ID) / COUNT( TOTAL {<FirstAgent={'<>0'}>}ID) )
, FirstName,LastName,Friendly_Name)* TMTcible/Count({<FirstAgent={'<>0'}>}ID))))
Thanks,
Hasvine
Try 'not equal to', like:
FirstAgent={'<0>0'}
Or,
FirstAgent -={'0'}
two aggr functions using not working it get the error
Hi Hasvine:
=-(1-(sum(total<Friendly_Name,FirstName,LastName>AGGR(
( COUNT( {<FirstAgent-={0}>}ID) / COUNT( TOTAL {<FirstAgent-={0}>}ID) )
, FirstName,LastName,Friendly_Name)* TMTcible/Count({<FirstAgent-={0}>}ID))))
Hope it helps,
Andrés
it taken the only count function
Hello All,
Thank you for your help. the set analysis part is good i believe that the issue lies either with the aggr or with the brackets which are wrongly position as I checked each set individually and it works fine.
Thanks,
Hasvine
Hi Hasvine, at first glance I can't tell you more without any sample data. Could you share some to let what's going on?
Cheers,
Andrés
Hi Andres,
I will send you a sample soon. I am preparing it.
Thanks
Hasvine
Hi. Your mistake is in using function 'Count' like argument of function 'Sum' with in combination with function 'Aggr':
=-(1-(sum(total<Friendly_Name,FirstName,LastName>AGGR(
( COUNT( {<FirstAgent={'<>0'}>}ID) / COUNT( TOTAL {<FirstAgent={'<>0'}>}ID) )
, FirstName,LastName,Friendly_Name)* TMTcible/Count({<FirstAgent={'<>0'}>}ID))))
if we remove expression 'Count({<FirstAgent={'<>0'}>}ID)' formula works.
May be this:
=-(1
-(Sum(TOTAL<Friendly_Name,FirstName,LastName>
Aggr(
(
Count({<FirstAgent={'<>0'}>}ID)/Count(TOTAL {<FirstAgent={'<>0'}>}ID)
),
FirstName,LastName,Friendly_Name))
*
TMTcible)
/
Count({<FirstAgent={'<>0'}>}ID))
or this:
=-(1
-(Sum(TOTAL<Friendly_Name,FirstName,LastName>
Aggr(
(
Count({<FirstAgent={'<>0'}>}ID)/Count(TOTAL {<FirstAgent={'<>0'}>}ID)
),
FirstName,LastName,Friendly_Name))
*
TMTcible
/
Count({<FirstAgent={'<>0'}>}ID)))