How to get amount of max month of max year?

[#1]

Kinldy correct me

=Sum({<FinYear= {$(=vMaxYear)}>}Amount) its giving max year amount

=Sum({<FinMonth= {$(=vMaxMonth)},FinYear= {$(=vMaxYear)}>}Amount) its not working

Thanxs Regards,

Usman

[simondachstr]

The error must obviously lie within FinMonth= {$(=vMaxMonth)}.

I suspect one of the following:

1) The month format is different. While FinMonth might expect e.g. 'Dec' vMaxMonth is an integer '12'.

2) There is no data available for maxmonth and maxyear, which of course depends on how you calculate the variables.

[#3]

Hmm thanxs i got your point now its working.

regards,

Usman