Skip to Content
0
Former Member
Feb 21, 2011 at 05:03 PM

How to select multiple currencies per variable at query runtime

26 Views

Hi Experts,

I have the following problem. I want to do a currency converision by variable per report row.

What is working is the currency concversion per variable for the whole query but I need to this per row/column independtly.

E.g.

Database

100USD

200EUR

150GBP

Query Result

100EUR

200EUR

150USD

based on a variable.

In other words the target currency needs to be determined independtly for every row. And not one variable for the whole query

Is this easily possible at runtime or do I need to create kind of a virtual characteristic containing the target currency?

Thanks in advance for your help.

Regards

Marcel