topic Dificuldade de achar valor inteiro in Brasil https://community.qlik.com/t5/Brasil/Dificuldade-de-achar-valor-inteiro/m-p/924677#M31263 <HTML><HEAD></HEAD><BODY><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">Tenho esta expressão feita pelo amigo clever.</P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;"> <SPAN style="font-weight: inherit; font-style: inherit;">If(Sum(Descontos) &gt;= 11, 1,</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px;">If(Sum(Descontos) &gt;= 6, 1.5,2)) / 100</SPAN></P><P></P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">Só que preciso multiplicar o campo Tabela abaixo.</P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">sum({&lt;[Movimento_Tipo_Operacao]={'DEV','VND','VPC','VEF','FPV','CVE'} &gt;}Preco_Final)* If(Sum(Desconto_Percentual) &gt;= 11, 1,If(Sum(Desconto_Percentual) &gt;= 6, 1.5,2)) / 100</P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;"></P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">Amigos não está dando certo.</P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">Alguma dica onde estou errando.</P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;"></P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;"></P><P><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px;"><IMG alt="2015-12-14_14-28-20.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/108979_2015-12-14_14-28-20.png" style="height: auto;" /><BR /></SPAN></P></BODY></HTML> Mon, 14 Dec 2015 18:33:30 GMT Ribeiro 2015-12-14T18:33:30Z Dificuldade de achar valor inteiro https://community.qlik.com/t5/Brasil/Dificuldade-de-achar-valor-inteiro/m-p/924677#M31263 <HTML><HEAD></HEAD><BODY><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">Tenho esta expressão feita pelo amigo clever.</P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;"> <SPAN style="font-weight: inherit; font-style: inherit;">If(Sum(Descontos) &gt;= 11, 1,</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px;">If(Sum(Descontos) &gt;= 6, 1.5,2)) / 100</SPAN></P><P></P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">Só que preciso multiplicar o campo Tabela abaixo.</P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">sum({&lt;[Movimento_Tipo_Operacao]={'DEV','VND','VPC','VEF','FPV','CVE'} &gt;}Preco_Final)* If(Sum(Desconto_Percentual) &gt;= 11, 1,If(Sum(Desconto_Percentual) &gt;= 6, 1.5,2)) / 100</P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;"></P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">Amigos não está dando certo.</P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">Alguma dica onde estou errando.</P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;"></P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;"></P><P><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px;"><IMG alt="2015-12-14_14-28-20.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/108979_2015-12-14_14-28-20.png" style="height: auto;" /><BR /></SPAN></P></BODY></HTML> Mon, 14 Dec 2015 18:33:30 GMT https://community.qlik.com/t5/Brasil/Dificuldade-de-achar-valor-inteiro/m-p/924677#M31263 Ribeiro 2015-12-14T18:33:30Z Re: Dificuldade de achar valor inteiro https://community.qlik.com/t5/Brasil/Dificuldade-de-achar-valor-inteiro/m-p/924678#M31264 <HTML><HEAD></HEAD><BODY><P>Qual valor está aparecendo?</P></BODY></HTML> Mon, 14 Dec 2015 18:35:47 GMT https://community.qlik.com/t5/Brasil/Dificuldade-de-achar-valor-inteiro/m-p/924678#M31264 Clever_Anjos 2015-12-14T18:35:47Z Re: Dificuldade de achar valor inteiro https://community.qlik.com/t5/Brasil/Dificuldade-de-achar-valor-inteiro/m-p/924679#M31265 <HTML><HEAD></HEAD><BODY><P>Fecha no número 3 está 282,48 x 2% 1,41</P><P><IMG alt="2015-12-14_16-05-52.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/108980_2015-12-14_16-05-52.png" style="height: 194px; width: 620px;" /></P></BODY></HTML> Mon, 14 Dec 2015 18:37:24 GMT https://community.qlik.com/t5/Brasil/Dificuldade-de-achar-valor-inteiro/m-p/924679#M31265 Ribeiro 2015-12-14T18:37:24Z Re: Dificuldade de achar valor inteiro https://community.qlik.com/t5/Brasil/Dificuldade-de-achar-valor-inteiro/m-p/924680#M31266 <HTML><HEAD></HEAD><BODY><P>Usa [Val. Venda]*[Media%]</P></BODY></HTML> Mon, 14 Dec 2015 18:48:33 GMT https://community.qlik.com/t5/Brasil/Dificuldade-de-achar-valor-inteiro/m-p/924680#M31266 Clever_Anjos 2015-12-14T18:48:33Z Re: Dificuldade de achar valor inteiro https://community.qlik.com/t5/Brasil/Dificuldade-de-achar-valor-inteiro/m-p/924681#M31267 <HTML><HEAD></HEAD><BODY><P>Engraçado Clever, o simples as vezes é tão complicado.</P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /></P></BODY></HTML> Mon, 14 Dec 2015 18:56:20 GMT https://community.qlik.com/t5/Brasil/Dificuldade-de-achar-valor-inteiro/m-p/924681#M31267 Ribeiro 2015-12-14T18:56:20Z