pick function with aggr, possible?

[samuel_brierley]

hi all,

the below equation is not working, not a clue why but can someone explain where im going wrong.

=pick(3,aggr(count({$<Fault_Classification = {'0','1','2','7'},
Fault_Code = {'-1','2','3','5','8','9','11','12','13','14','15','16','25','27'} >}Fault_Id),Equipment_Id))

ive replaced pick with max and min so im confident the aggr function is correct.

tahksn all.

[swuehl]

What would be your expected result? I don't see a third argument in pick() function after your switch number.

pick( Number,

CaseNumberEquals1,

CaseNumberEquals2,

CaseNumberEquals3

)

[samuel_brierley]

the intention was that the Aggr function would create the mini table and the pick function would pick the nth number in that table.

[swuehl]

That's not like pick() works.

try maybe

=FirstSortedValue( {$<Fault_Classification = {'0','1','2','7'},
Fault_Code = {'-1','2','3','5','8','9','11','12','13','14','15','16','25','27'} >}

aggr(count({$<Fault_Classification = {'0','1','2','7'},
Fault_Code = {'-1','2','3','5','8','9','11','12','13','14','15','16','25','27'} >}Fault_Id),Equipment_Id)

, aggr(rowno() ,Equipment_Id), 3)