Get the last sale of the year in set analysis

[MarioCenteno]

Hello community I have the following challenge I want to get the last sale of the year in set analysis, I have an expression that adds the sales to the YTD but it is not the data I need, I want to obtain the utmost record of the accumulated sales.

Value currently displayed  $35771,846

The correct value is $10719408.

Expression

SUM({<[F_IFR.autoCalendar.Year]={'$(vMaxYear)'},F_IFR={'<=$(vMaxDate)'},

[F_IFR.autoCalendar.Date]=,[F_IFR.autoCalendar.Date]=,[F_IFR.autoCalendar.YearMonth]=>}REAL_ACUM)

[MarioCenteno · Accepted solution]

I could solve it with the following expression:

SUM({<REAL_ACUM={$(=(max(REAL_ACUM)))},[F_IFR.autoCalendar.Year]={'$(vMaxYear)'},F_IFR={'<=$(vMaxDate)'},

[F_IFR.autoCalendar.Date]=,[F_IFR.autoCalendar.Date]=,[F_IFR.autoCalendar.YearMonth]=>}REAL_ACUM)