I have a difficult query that I am trying to pull off where we have a Billing Currency and an Invoicing Currency. We then have an Exchange Rate attribute that will be used in calculated fields that we want to be pulled through based on the exchange rate table that is stored within Clarity. I have the currency attributes setup and the rates in the exchange rate tables. I am having difficulty pulling off the dynamic query that ties it all together. Any help would be greatly appreciated!
Can you provide more details? Maybe a draft of the query that is not working.