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