Question about rates

[#1]

Hey guys,

In my database, I have a a rate table which loads new values in the currencyrate everyday. Thing is it is mapped to EUR (is set to 1)

So to get everything into one currency my exression looks like: Sum(turnover/rate_eur)

If I would like the turnover in say CHF is it a easy way of doing that in the expression somehow?

In excel file:

Thanks!

[sunny_talwar]

Can you provide the above data in an excel file so that we can create a sample for you?

[#3]

I have a monthly QVD with data? for rates... what is it that you need?

Thanks

[sunny_talwar]

The data that you are showing above in a excel file (instead of pasting it as an image).

[avinashelite]

You need to show the Turnover column in respective rate currency value??

if that is the case , you could create a inline list box to select the respective currency values like USD,EUR etc based on the you write your expression to pick the conversion rate values

[#6]

Ok, see top Thanks

[#7]

Ok, yes At least in EUR and SEK not turnover in every separate currency. Yeah ok, how would that be done? sorry im new to this..

[sunny_talwar]

Check this out:

CurrencyTable:

LOAD * Inline [

Currency, rate_eur

GBP, 0.78805

EUR, 1

CHF, 1.09783

];

CurrencyMapping:

Mapping

LOAD *

Resident CurrencyTable;

Table:

LOAD *,

  Turnover / ApplyMap('CurrencyMapping', Local_Currency) as Turnover_eur

Inline [

Turnover, Local_Currency

50, CHF

60, GBP

20, EUR

];

Data Model: Showing two island tables

[#9]

This looks liek ti but this will give me a static currency rate. I need it more dynamic since the currencies updates everyday.

[sunny_talwar]

This was just an example, you would be loading the currency table from a source which updates daily and this will make sure that you have most recent data in your application

CurrencyTable:

LOAD *

FROM CurrencyTableSource;

CurrencyMapping:

Mapping

LOAD Currency,

           Rate

Resident CurrencyTable;

Table:

LOAD *,

  Turnover / ApplyMap('CurrencyMapping', Local_Currency) as Turnover_eur

Inline [

Turnover, Local_Currency

50, CHF

60, GBP

20, EUR

];