Want to find Max.

[Sxbbb]

Want to find Max of Type = CU IN HOLE DIF

[BrunPierre]

Maybe this

Aggr(Only({<CU_BoardNo={"$(=Max(CU_BoardNo))"},CU_TypeHole={'CU IN HOLE DIF'}>}CU_TypeHole),FA_ID)

[Sxbbb]

This is result 

but I want Result Type = CU IN HOLE DIF

[BrunPierre]

Give it another go.

Sum(Aggr(Sum({<CU_BoardNo={"$(=Max(CU_BoardNo))"},CU_TypeHole={'CU IN HOLE DIF'}>}CU_HoleMax),FA_ID))

[Sxbbb]

This is  result . but I want Result Type  CU IN HOLE DIF  =40.29 

[MayilVahanan]

Hi 

Try like below

Max(Aggr(Sum({<CU_BoardNo={"$(=Max(CU_BoardNo))"},CU_TypeHole={'CU IN HOLE DIF'}>}CU_HoleMax)

,FA_ID,CU_BoardNo))

[Sxbbb]

This is result.

[Sxbbb]

not as desired

[Sxbbb]

Want max value 

with different ID 

[BrunPierre]

Maybe add RecNo() to your load script like this.

LOAD CU_TypeHole
.......,
RecNo() as R#

FROM SourceTable;

And here's an expression you can try

Sum(Aggr(Sum({<CU_BoardNo={"$(=Max(CU_BoardNo))"},CU_TypeHole={'CU IN HOLE DIF'},R#={"$(=Max(R#))"}>}CU_HoleMax),CU_BoardNo,FA_ID))