Subtraction of two SET Variables

[kvr9]

Hello,

I'm stuck with an issue with subtraction. My data contain two variables was trying to subtract them but it is not working properly

Set vCountry=1,

Set vValue =if(vCountry =1,Localcurrency, Localcurrency*exchangerate)

Set vSale =if(vCountry=1,Sales,Sales*exchangerate)

above is the variables I have created for my data and was trying to subtract them as below.

vValue -vSale

I am getting result for local values but not the converted values i.e if country is 0 or more than 1 then it should convert using exchange rates but it is not working as expected

Can some one help me out.

Thanks.

[Anil_Babu_Samineni]

In that 3rd image, Should select USD only. can you show the data points using USD selection. You need to get 1.7 $. Aren't you?

[kvr9]

The 3rd Image is shows correct calculation ,we need calculation based on conversion I.e USD and EUR.

EUR calculation is perfect,coming to my 2nd Image $26.8 -$0.2 is $26.6 but I'm getting $24.9.Which is wrong upon my analysis found the calculation is not reflecting for conversion (USD).

[sasiparupudi1]

Please try

=Num

(

(SUM({<Year={$(=max(Year))},[Payment Type]={'R&D'}>}if($(vLocalValue)=1,(DisclosedToV*ExchangeRateToUSD), DisclosedToV)/UnitDivision))

-

(sum({<Year={$(=max(Year))},[Payment Type]={'R&D'}>} if($(vLocalValue) =1, SpendAmount, (SpendAmount/ExchangeRateToUSD))/UnitDivision),'$(vNumberFormat)')

)

[kvr9]

Hi Sasidhar,

The above expression works fine ,but I would like to replace it with variables.

Set vValueField = =if(vLocalValue=1, '[SpendAmount]', '[SpendAmount]/[ExchangeRateToUSD]');

Set vDisclosedToV = =if(vLocalValue=1,'[DisclosedToV]*[ExchangeRateToUSD]', '[DisclosedToV]');