I have a field 'TYPE' , 'Wire ' , 'Output ' ,'Part', 'Number'
in field 'TYPE' contains data 'TYPE1' and 'TYPE2'
in field 'Wire' contains data 'Wire1' and 'Wire2'
I want to display the value 'Output *'Number'
If 'Part' is in 'TYPE1' and 'Part' must be in both 'Wire1' and 'Wire2'.
I tried this code but the value is incorrect:
(Sum({<Wire={'Wire1'},Wire={'Wire2'}, TYPE={'TYPE1'}>} Aggr((Output *'Number),Part,,WorkOrderNo)))