https://community.qlik.com/t5/App-Development/Sum-Aggr-FirstSortedValue-Problem/m-p/1825750#M67883 <P>Hello. I´m usig sum(Aggr(FirstSortedValue(acum_margen_bruto,-mes_mg_bruto),mes_alta))-(14.51*(max(clientes,mes_alta)))&nbsp; and this expression is not doing what I need and dont know how solve it.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Qlik-ejemplo mal1.JPG" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/59485iAD7F4594E5632DDD/image-size/medium?v=v2&amp;px=400" role="button" title="Qlik-ejemplo mal1.JPG" alt="Qlik-ejemplo mal1.JPG" /></span></P><P>Single amounts ar correct, but Total amount is incorrect.&nbsp; How can I solve.</P><P>&nbsp;</P><P>Thanks.</P><P> </P> Fri, 30 Jul 2021 11:30:21 GMT JVET 2021-07-30T11:30:21Z https://community.qlik.com/t5/App-Development/Sum-Aggr-FirstSortedValue-Problem/m-p/1825750#M67883 <P>Hello. I´m usig sum(Aggr(FirstSortedValue(acum_margen_bruto,-mes_mg_bruto),mes_alta))-(14.51*(max(clientes,mes_alta)))&nbsp; and this expression is not doing what I need and dont know how solve it.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Qlik-ejemplo mal1.JPG" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/59485iAD7F4594E5632DDD/image-size/medium?v=v2&amp;px=400" role="button" title="Qlik-ejemplo mal1.JPG" alt="Qlik-ejemplo mal1.JPG" /></span></P><P>Single amounts ar correct, but Total amount is incorrect.&nbsp; How can I solve.</P><P>&nbsp;</P><P>Thanks.</P><P> </P> Fri, 30 Jul 2021 11:30:21 GMT https://community.qlik.com/t5/App-Development/Sum-Aggr-FirstSortedValue-Problem/m-p/1825750#M67883 JVET 2021-07-30T11:30:21Z https://community.qlik.com/t5/App-Development/Sum-Aggr-FirstSortedValue-Problem/m-p/1826239#M67945 <P>Any idea? Thanks</P> Tue, 03 Aug 2021 07:29:13 GMT https://community.qlik.com/t5/App-Development/Sum-Aggr-FirstSortedValue-Problem/m-p/1826239#M67945 JVET 2021-08-03T07:29:13Z https://community.qlik.com/t5/App-Development/Sum-Aggr-FirstSortedValue-Problem/m-p/1826679#M67992 <P>You may need another sum(aggr()) wrapping your expression.</P><P>- Marcus</P> Wed, 04 Aug 2021 15:25:00 GMT https://community.qlik.com/t5/App-Development/Sum-Aggr-FirstSortedValue-Problem/m-p/1826679#M67992 marcus_sommer 2021-08-04T15:25:00Z