You’re offline. This is a read only version of the page.
Announcements
271
I have a table with daily exchange rate data called Daily Exchange Rates.
I have another table, Investment Balance, in which I have to convert a column called Foreign Balance, to another column called Local Balance, using the AVERAGE exchange rate of the month.
How on earth do I do this?
I know the Local Balance column must be of type formula, but I don't know how to write the formula to look at the Balance Date, and use that to extract an average from the other table, and then do the calculation.
Share
Report
All responses (
Answers (
