Hi - I'm using Netsuite 2019.1 version and working on SuiteAnalytics standard workbook called: "Sales (Invoiced) Workbook". The Amount (Net) column shows the amount in local currency but I want to convert the local currency into USD using consolidated exchange rate for specified accounting period. To convert the currency I added a column in the workbook with following formula. But looks like it's converting currency based on currency exchange rate based on date specified in formula (here it is 11/30/2019). Can someone please help me how can I edit this formula so it will convert the currency (amount in "Amount (Net)" column) using consolidated exchange rate for specified period?
Formula: TO_NUMBER({amountnet#converted[1;2019-11-30]})