topic Re: Sum with conditions in QlikView https://community.qlik.com/t5/QlikView/Sum-with-conditions/m-p/789552#M279213 <HTML><HEAD></HEAD><BODY><P>Can you share your qvw and the expected output?</P></BODY></HTML> Wed, 25 Mar 2015 11:59:04 GMT Anonymous 2015-03-25T11:59:04Z Sum with conditions https://community.qlik.com/t5/QlikView/Sum-with-conditions/m-p/789549#M279210 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>I have a problem with sum in pivot table.</P><P></P><P>I have a condition to convert all other currency in USD.</P><P></P><P>Here is my expression:</P><P></P><P>IF([Currency of Agreement]='UAH', Bench*Sum([Base Salary, Gross]/vUSDrate),if([Currency of Agreement]='PLN', Bench*Sum([Base Salary, Gross]/vPLNrate),Bench*sum([Base Salary, Gross])))</P><P></P><P>It doesnt sum properly, anyone can point out my mistake here?</P></BODY></HTML> Wed, 25 Mar 2015 11:48:23 GMT https://community.qlik.com/t5/QlikView/Sum-with-conditions/m-p/789549#M279210 2015-03-25T11:48:23Z Re: Sum with conditions https://community.qlik.com/t5/QlikView/Sum-with-conditions/m-p/789550#M279211 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P>IF([Currency of Agreement]='UAH', (Bench*Sum([Base Salary, Gross]))/vUSDrate,if([Currency of Agreement]='PLN', (Bench*Sum([Base Salary, Gross]))/vPLNrate,Bench*sum([Base Salary, Gross])))</P></BODY></HTML> Wed, 25 Mar 2015 11:52:02 GMT https://community.qlik.com/t5/QlikView/Sum-with-conditions/m-p/789550#M279211 Anonymous 2015-03-25T11:52:02Z Re: Sum with conditions https://community.qlik.com/t5/QlikView/Sum-with-conditions/m-p/789551#M279212 <HTML><HEAD></HEAD><BODY><P>No, it doesnt sum properly,the numbers are too huge</P></BODY></HTML> Wed, 25 Mar 2015 11:54:29 GMT https://community.qlik.com/t5/QlikView/Sum-with-conditions/m-p/789551#M279212 2015-03-25T11:54:29Z Re: Sum with conditions https://community.qlik.com/t5/QlikView/Sum-with-conditions/m-p/789552#M279213 <HTML><HEAD></HEAD><BODY><P>Can you share your qvw and the expected output?</P></BODY></HTML> Wed, 25 Mar 2015 11:59:04 GMT https://community.qlik.com/t5/QlikView/Sum-with-conditions/m-p/789552#M279213 Anonymous 2015-03-25T11:59:04Z Re: Sum with conditions https://community.qlik.com/t5/QlikView/Sum-with-conditions/m-p/789553#M279214 <HTML><HEAD></HEAD><BODY><P>I solved the problem with: IF([Currency of Agreement]='UAH', Sum([Base Salary, Gross]/vUSDrate *Bench),if([Currency of Agreement]='PLN', Sum([Base Salary, Gross]/vPLNrate*Bench),Sum([Base Salary, Gross]*(Bench))))</P></BODY></HTML> Wed, 25 Mar 2015 11:59:51 GMT https://community.qlik.com/t5/QlikView/Sum-with-conditions/m-p/789553#M279214 2015-03-25T11:59:51Z