Converting price

I have a module called FX01 Currency Rates. It has 6 Currencies and their rates for 2024, monthly.

I have another Module called REV04 Sales Volume Budget. where by customer and SKU there's an input for volume and price. The price is by SKU currency. The SKU currency is brought in a line item. I want to have a rate line item where it does the following;if the SKU currency is USD then bring 1 (that is the base currency therefore USD is always 1) if it is not USD then refer to the FX01 Currency Rates module and bring the corresponding rate

I have tried multiple options, but none of them would pull the data

what am I missing?

Answers