Skip to Content
0
Former Member
Feb 14, 2007 at 06:00 PM

BW Currency Conversion with rate of next year

53 Views

Hi,

I need to show cumulated values of previous year(PYTD) converted with the exchange rate of the current year (e.g. Jan 06 value converted with Jan 07, Feb 06 with Feb 07 etc.).

I can't upload the converted value, because the rate (monthly average) is fixed at the end of the month.

Is ther any solution to do this at query runtime?

I tried RRC1 etc., but got nowhere yet,

thanks,

Stephan