You’re offline. This is a read only version of the page.
200
I need to write and income statement report that shows each line at our planning rate currency, then shows an FX recalculation figure to get the total to US dollars. Example:
Revenue item 1 C$xxx.xx
Revenue item 2 C$xxx.xx
FX recalc $xxx.xx
Total revenue $xxx.xx (USD)
Is there any way within the row format to specify which currency to use? The only other way I can think of to do this is to have one hidden column with the CAD currency and one with the USD, and subtract the 2 in the FX recalc line. The problem with that is that the report has 13 monthly columns, plus YTD, YTD budget, LTM current year and LTM prior year. It gets pretty messy with all those columns.
Any suggestions?
Hello,
The only way to make the row pull different currencies is to either not set it to use translation or to use a different currency method like CCSPOT, CCAVG, or CCHIST.
For example, you could translate lines 1 and 2 using CCSPOT and then make sure you don't specify a method for use on the Total Revenue line.
Share
Report
All responses (
Answers (
