Share
Report
200I 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?
All responses (
Answers (
