FX variables hold the resulting foreign exchange fluctuation or differences that result when summed variables are converted using different Rate Types (e.g. Average rate and Closing rate)
To handle that exchange difference, and ensure that any subsequent calculations show the correct converted amount, FX variables are inserted into the variables list.
Once you establish where the cross currency conversions are occurring between the variables, insert a new variable immediately above the affected calculated variable.
This new variable should take the same name as the calculated variable with FX as a prefix and it should be assigned as an FXVar.
In the generated model, this new variable will hold any exchange differences as a result of the differing rate types. When viewing data on this variable, it will only display values in Base Currency. There is no calculation of exchange differences in Local Currency.
Post your comment on this topic.