Selection should not effect ?

[gauravgg]

Hi

I have the following two expression

count(distinct{<Part={"=count(Part)=Max(TOTAL Aggr(Count(Part),Part))"}>}Part)

count(Aggr(if(Count(DISTINCT [FG Desc]&PLANT) =1,Part),Part))

I dont want the effect of selection for a perticular field on that expressions

can anyone help me

thanks in Advance

[Anil_Babu_Samineni]

Try this?

count(distinct{1<Part={"=count(Part)=Max(TOTAL Aggr(Count(Part),Part))"}>}Part)

count(Aggr(if(Count({1} DISTINCT [FG Desc]&PLANT) =1,Part),Part))

[stabben23]

Hi,

then you need to add these Fields in you set analysis, try like this in bold.

count(distinct{<Field1,Field2,Field3, Part={"=count(Part)=Max(TOTAL Aggr(Count(Part),Part))"}>}Part)

count({<Field1,Field2,Field3>}Aggr(if(Count(DISTINCT [FG Desc]&PLANT) =1,Part),Part))

[its_anandrjs]

Try one of this

count({1} distinct{<Part={"=count(Part)=Max(TOTAL Aggr(Count(Part),Part))"}>}Part)

count({1} Aggr(if(Count(DISTINCT [FG Desc]&PLANT) =1,Part),Part))

[gauravgg]

No ,it is not working

thanks for reply

[gauravgg]

No ,it is not working

thanks for reply

[gauravgg]

No ,it is not working

thanks for reply

[shraddha_g]

Try

count({1} distinct{<Part={"=count({1}Part)=Max({1} TOTAL Aggr(Count({1}Part),Part))"}>}Part)

count({1} Aggr(if(Count({1} DISTINCT [FG Desc]&PLANT) =1,Part),Part))

[Anil_Babu_Samineni]

How about this?

Only({1} count(distinct{<Part={"=count(Part)=Max(TOTAL Aggr(Count(Part),Part))"}>}Part))

Only({1} count(Aggr(if(Count(DISTINCT [FG Desc]&PLANT) =1,Part),Part)))

If not, i would respect to ask share image where you done

[gauravgg]

No ,it is not working