topic Re: Dúvida SOMAR in Brasil https://community.qlik.com/t5/Brasil/D%C3%BAvida-SOMAR/m-p/663143#M18930 <HTML><HEAD></HEAD><BODY><P>Tenta assim</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=sum({&lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">[Peso Bruto Nota]</SPAN>={'&gt;300'}&gt;}[Frete Kg - Sistema] * [Peso Bruto Nota])</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P></BODY></HTML> Wed, 27 Aug 2014 14:49:23 GMT junior_ehlke 2014-08-27T14:49:23Z Dúvida SOMAR https://community.qlik.com/t5/Brasil/D%C3%BAvida-SOMAR/m-p/663142#M18929 <HTML><HEAD></HEAD><BODY><P>Prezados,</P><P></P><P>Estou tentanto apenas multiplicar fretes com mais de 300kg, minha expressão:</P><P></P><P>=sum({&lt;[Frete Kg - Sistema] * [Peso Bruto Nota]={'&gt;300'}&gt;})</P><P></P><P>Peço ajuda vocês em minha expressão.</P></BODY></HTML> Wed, 27 Aug 2014 14:43:12 GMT https://community.qlik.com/t5/Brasil/D%C3%BAvida-SOMAR/m-p/663142#M18929 2014-08-27T14:43:12Z Re: Dúvida SOMAR https://community.qlik.com/t5/Brasil/D%C3%BAvida-SOMAR/m-p/663143#M18930 <HTML><HEAD></HEAD><BODY><P>Tenta assim</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=sum({&lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">[Peso Bruto Nota]</SPAN>={'&gt;300'}&gt;}[Frete Kg - Sistema] * [Peso Bruto Nota])</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P></BODY></HTML> Wed, 27 Aug 2014 14:49:23 GMT https://community.qlik.com/t5/Brasil/D%C3%BAvida-SOMAR/m-p/663143#M18930 junior_ehlke 2014-08-27T14:49:23Z Re: Dúvida SOMAR https://community.qlik.com/t5/Brasil/D%C3%BAvida-SOMAR/m-p/663144#M18931 <HTML><HEAD></HEAD><BODY><P>Boa tarde Diego</P><P></P><P>Outra solução pode ser (Sum(If([Peso Bruto Nota] &gt; 300, [Peso Bruto Nota], 0) * <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">[Frete Kg - Sistema])</SPAN></P></BODY></HTML> Wed, 27 Aug 2014 16:59:25 GMT https://community.qlik.com/t5/Brasil/D%C3%BAvida-SOMAR/m-p/663144#M18931 Marcio_Campestrini 2014-08-27T16:59:25Z