Aggregation with sum and max?

[olramirez]

Hello,

i have a report with a variable for expression but the final total is wrong.

Send my report, the final total should be 170,633,792 but this is 2,265,797,212 !!

Please help me.

Olga

[sunny_talwar · Accepted solution]

Change your variable to this

Sum(Aggr(IF(Max({$<Año=, Mes=, MonthYear={'$(=max(MonthYear))'}>}Precio)=0,

        sum(Aggr(Max({$<Año=, Mes=, MonthYear={'$(=max(MonthYear))'}>}Valor),IdFolio)),

        Sum({$<Año=, Mes=, MonthYear={'$(=max(MonthYear))'}>}Valor)

      ), Centro, IdFolio, %FECHA, %ID_ARTICULO))

[olramirez]

Thanks Sunny