Sum with conditions

[#1]

Hi!

I have a problem with sum in pivot table.

I have a condition to convert all other currency in USD.

Here is my expression:

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])))

It doesnt sum properly, anyone can point out my mistake here?

[Anonymous]

Try this

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])))

[#3]

No, it doesnt sum properly,the numbers are too huge

[Anonymous]

Can you share your qvw and the expected output?

[#5 · Accepted solution]

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))))