I want all values ​​to be displayed in the table by CodePart

[Sxbbb]

I want Max=15 value of CodePart='A3030#1' from every cell in the table.

and Other CodePart also display the Max value. every line in the table

like this

I'm currently trying this code :

Aggr(Max( (Aggr( Sum( Aggr(if(CycleTime_Sec > 0 ,CycleTime_Sec,'0'),Number,WSGroup)/((sum(INPUT) + Sum([INTERNAL])) - sum(Aggr(DISTINCT xWorkOrder, CodePart,Part,Number)) + Sum([TEST])),CodePart,Part))),CodePart)

[MayilVahanan · Accepted solution]

Hi

Might be, try like this

Max(Total<CodePart> (Aggr( Sum( Aggr(if(CycleTime_Sec > 0 ,CycleTime_Sec,'0'),Number,WSGroup)/((sum(INPUT) + Sum([INTERNAL])) - sum(Aggr(DISTINCT xWorkOrder, CodePart,Part,Number)) + Sum([TEST])),CodePart,Part)))

[Sxbbb]

Thank you very much, I can do what I want.