This content has been marked as final. Show 6 replies
Hi! I have a table of data of the structure (lets call it Sales):
Along with a currency conversion table of the structure:
What I want to do is to add a field in the Sales (due_total_myCurrency) that takes the due_total and multiplies it with the currency_value of the same currency_code AND year. The currency conversion table is created with the crosstable prefix.
Any Ideas would be greatly appreciated!