Requirement:
Create a workbook and a dataset with the bills for the 2023 year. The workbook and the data set should be named Bills of 2023 Workbook and Dataset, respectively. Add the information related to the item on the bills. (Name, transaction amount, date, etc.) Make a chart that displays the bill amount for each individual item. Show it on the dashboard, too. If there are no bills in the current year, create five bills with different items.
The amount is displayed in different currencies in the amount filed in workbook, according to the currency in corresponding bill.
Could you please clarify whether it is possible to display amount in base currency in the workbook?
Solution:
We can calculate the amount in base currency by multiplying the bill amount with exchange rate in the bill, and display it in a new column.
Or, select Transaction Accounting Line, and then select amount.
Also, the amount can be displayed as positive values by applying following formula:
ABS(TO_NUMBER({transactionlines.accountingimpact.netamount}))