Problem when divinding / multiplying

silvia_assuncao — Tue, 19 May 2015 12:12:31 GMT

Hello All!

I'm having a problem when dividing values in Local Curreny by USD Rate for different countries in order to have them all in American Dolar Currency. I using the expression:

Sum(Local_Value)/(Rate_USD)

Below you can see my table:

Country	Rate_USD	Local_Value	Classification
Brazil	3,12	0	Depreciation / Amortization
Brazil	3,12	80	Hardware
Brazil	3,12	12	Others
Brazil	3,12	-99	Outsourced Services
Brazil	3,12	58	People
Brazil	3,12	72	Software
Brazil	3,12	-17	Telecom
Brazil	3,12	-4	Training
Brazil	3,12	-7	Travel
Argentina	8,7918	-22	Contractors
Argentina	8,7918	-33	Depreciation / Amortization
Argentina	8,7918	11	Hardware
Argentina	8,7918	1	Others
Argentina	8,7918	-4	Outsourced Services
Argentina	8,7918	1	People
Argentina	8,7918	-14	Software
Argentina	8,7918	1	Travel

The problem is that Using this expression I have the righ values if I select a charge using dimension as Contries, but if I change the dimention to Classification, the values get all wrong.

Could you suggest me how could I fix my expression so that no matter what kind of dimention, I'd have the right values always?

Thanks and best Regards,

Re: Problem when divinding / multiplying

maxgro — Tue, 19 May 2015 16:04:07 GMT

try

Sum( Local_Value / Rate_USD )

topic Problem when divinding / multiplying in QlikView

Problem when divinding / multiplying

Re: Problem when divinding / multiplying