Max Date in Set Analysis

[Prabhu1204]

Hello All,

I wanted to Calculate the Sum of R&D Cost only for the Maximum of PAB date.

I used the below set expression and it is not coming for all the values tough  the PAB date is there.

Could you please help

Expression:  Sum({$<[PAB date] = {"$(=Date(Max([PAB date]), 'MM/DD/YYYY'))"}>} [R&D Costs
(Gross)])

[Prabhu1204]

@sunny_talwar , I used the expression which you have posted in Different Blog. 

[tm_burgers · Accepted solution]

sum(if(PAB_Date = aggr(nodistinct max(PAB_Date),Platform),[R&D Costs Gross]))

will give you the correct Values for your Top Table.