Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
How do I convert a field to another currency via Workbook Analytics?
Hi experts, I have this problem, I have advances to suppliers in different currencies and I need a report that allows me to estimate the net amount of debt to suppliers in the same currency. In Analytics I prepare a dataset and try to convert the values in foreign currency to local currency. I use the entity^vendor.prepaymentbalance field with the TO_NUMBER formula and the #converted or #currency_consolidated context but it doesn't work. would anyone know why it doesn't work and how to make it work?