Nested aggregation / disregard selections

[Oberpfälzer]

Hi,

I have a nested aggregation:

count(
if(
Aggr( count( [Artikel-NR]),PTU_IDENT)>1
and
LGTYP ='MPS'
,Aggr( count( [Artikel-NR]),PTU_IDENT)

)
)

Where do i put the {1} ,to let it disregard selections?

i tried sth like:

count( {1}
if(
Aggr({1} count( [Artikel-NR]),PTU_IDENT)>1
and
LGTYP ='MPS',
Aggr({1} count( [Artikel-NR]),PTU_IDENT)

)
)

but It's not working a 100%.

[sunny_talwar · Accepted solution]

Try this

Count({1} Aggr(
  If(
    Count({1} [Artikel-NR]) > 1 and
    Only({1} LGTYP) ='MPS',
  Count({1} [Artikel-NR]))
, PTU_IDENT))

[Oberpfälzer]

thanks , your solution works 🙂