Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I hope that you will be able to help me.
I need the AmountTeam by distinct TeamID. This aggr works for me:
if(( Sum(aggr((AmountTeam), (TeamID))))>10, (count (distinct TeamID)), 'select more')
But now I need to add a selected year to it. The one below does ignore the date:
if(( Sum(aggr((AmountTeam), (TeamID), (year='2020')))))>10, (count (distinct TeamID)), 'select more')
How can I include another condition? And also, I need to combine the part:
if(( Sum(aggr((AmountTeam), (TeamID))))>10 with this:
sum ( {1<[year] = {'2020'}, [productive] = {'1'} ,[work] = {control},[controlTyp] -= {'P'} >} Fees) /
count ( {1<[year] = {'2020'}, [productive] = {'1'} ,[work] = {control},[controlTyp] -= {'P'} >} distinct TeamID)
I have tried to find a solution but non of them works. Could you please help me with this?
Thank you very much!
Regards,
Inch
Hi @Inch13 ,
Can you please share the screenshot, where you want to use the required the expression?
And it will be great if you share the sample data.