Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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%.
Try this
Count({1} Aggr(
If(
Count({1} [Artikel-NR]) > 1 and
Only({1} LGTYP) ='MPS',
Count({1} [Artikel-NR]))
, PTU_IDENT))
Try this
Count({1} Aggr(
If(
Count({1} [Artikel-NR]) > 1 and
Only({1} LGTYP) ='MPS',
Count({1} [Artikel-NR]))
, PTU_IDENT))
thanks , your solution works 🙂