Has anyone here had any experience with using curr...
# suiteanalytics
a
Has anyone here had any experience with using currency formulas and converting the amount to the base currency or to USD? I am recreating the income statement with just the income account type. However, the currency for the non us subsidiaries are not converting to the base USD. The formula i am using (one for each month) CASE WHEN TO_CHAR({trandate}, 'MM') = '01' THEN {amount} ELSE 0 END