I have a saved search, aging summary, a workbook and a balance sheet.
Our root subsidiary base currency is USD.
The total AR per saved search, aging summary and balance sheet are all equal except for the workbook.
My formula in the workbook is TO_NUMBER({transactionlines.accountingimpact.amount#currency_consolidated}).
Why is that the case?