Sum-Aggr-FirstSortedValue Problem

[JVET]

Hello. I´m usig sum(Aggr(FirstSortedValue(acum_margen_bruto,-mes_mg_bruto),mes_alta))-(14.51*(max(clientes,mes_alta)))  and this expression is not doing what I need and dont know how solve it.

Single amounts ar correct, but Total amount is incorrect.  How can I solve.

Thanks.

 

[JVET]

Any idea? Thanks

[marcus_sommer]

You may need another sum(aggr()) wrapping your expression.

- Marcus