AGGR Function

[kishorj1982]

Hi All,

I need to show unit cost for max(DtDate) for combination of  branch plant and part number.

I used below formulae but no luck.

sum({<DtDate={'$(=max(aggr(max(DtDate),BranchPlant,PartNumber)))'}>} UnitCost)

Thanks

[sunny_talwar]

May be create a new field in the script like this

AutoNumber(BranchPlant&PartNumber) as NewField

and then try this

Sum({<NewField = {"=DtDate = Max(TOTAL <NewField> Aggr(DtDate, NewField, DtDate))"}>}UnitCost)

[tresesco]

May be using a straight table:

Dim1: BranchPlant

Dim2: PartNumber

Exp: FirstSortedValue( Aggr(Sum(UnitCost),DtDate), -DtDate)