data problem

[#1]

i use this formula to calculate this data AUM

Date Field	AUM
1	10
4	20
5	21
6	22
7	23
9	24
10	25
11	26
15	27

=sum({$<[Execution Date]={'$(Vmaxdate)'},max({<[Execution Date] = {"<$(=max([Execution Date]))"}>}[Execution Date])>}AUM)

when i use this formula =date(max({<[Execution Date] = {"<$(=max([Execution Date]))"}>}[Execution Date]),'DD-MMM-YYYY')

for calculating last date it works well but while summing it gives me 0.please check this where i am going wrong also attached qvd if found a solution.

[sunny_talwar]

There is nothing attached. Would you be able to share a sample?