Hi, I have some hefty data of the following nature that I would like to change currency:
| Country | Year | Value1 | Value2 | Value3 | Value4 |
| X | FY17 | 100 | 300 | 250 | 400 |
| X | FY18 | 100 | 300 | 250 | 400 |
| Y | FY19 | 100 | 300 | 250 | 400 |
| X | FY17 | 100 | 300 | 250 | 400 |
| Z | FY18 | 100 | 300 | 250 | 400 |
| Y | FY17 | 100 | 300 | 250 | 400 |
| X | FY18 | 100 | 300 | 250 | 400 |
Now since I know the exchange rate of a particular country for a specific year, I would like a multifield formula that would look up the country and year, then divide each valued column by the specific exchange rate. The exchange rate can be input within the formula or from a table input. I am open to recommendations on the best way.
Can anyone figure out a way to do this? I am uncertain of how to achieve this since both string and double fields would be considered in the formula with only double fields bearing the calculation.
Or is there another way?
Thanks
