help scripting - value not appearing

[qlikmpate0]

Problem trying to get a conversion rate for each transaction.

Background, Conversion rate are set up on monthly basics, so if a transaction falls within that month I would like to get the conversion rate.

My final output look like this.

The columns highlighted (Curr C/L, O/S Invs, App Ords, Total exposure, avail Credit line), need to be converted to Euros, but the all columns are already in euros except the last customer United Kingdom.

So I had an idea great in theory but not in practice.

I need to get a date of the transaction, find the from budget currency and to budget currency ie GBP to EUR and EUR to EUR then use that conversion rate, but my theory isn’t showing any values for conversion rate.

Thanks in advance.

regards

M