Currency Conversion - Multi Change

[#1]

Hi All,

Happy New Year to the Community.

My challenge for the beginning of 2014 is my budget program. In 2014 I decided it was time to unify two data-sources (same structure) one with currencies in Euro the other one in GBP. The main currency of choice is Euro.

My challenge is to display the currencies in TRN (Transaction), Converted Euro and for added 'fun' Converted USD. I would like the end user to be able to view a chart in any one of the 3 scenario's noted by clicking on 'something'

I have successfully as separate fields have converted transactional amounts in converted Euro and converted USD within the load script.

I appreciate that there are probably a few ways of doing this - my 1st thought was bookmarks and set analysis, I also thought of variables but unsure of this route. Set Analysis (and possibly lack of experience) has given me challenges that I would prefer to avoid if I can.

     CIC_NETINCOME,

     ApplyMap('EuroRate', CIC_CURRENCYCODE, null()) as EuroRate,

     ApplyMap('USDRate', CIC_CURRENCYCODE, null()) as USDRate,

Is the extract of code I have used and in any chart I use CIC_NETINCOME (Transactional), CIC_NETINCOME * EuroRate (Euro) or CIC_NETINCOME * USDRate (USD).

Any thoughts/wisdom would be appreciated - I am looking for an elegant approach

Many thanks

Rob

[#2 · Accepted solution]

Hi All,

I got this working using a variable vCurrency

=sum(if(CIC_COMPARABLE = 'Current'  AND vCurrency ='Euro', CIC_EURNETINCOME

,if(CIC_COMPARABLE = 'Current'  AND vCurrency ='USD', CIC_USDNETINCOME ,0)))

I can elaborate further if anyone finds this useful.

Thanks,

Rob

[#3]

Hi Robert,

Could you share the QVW. It would be helpful.

Thanks & Regards,

Keerthi