Hi all,
In table builder I have an amount field from sales line in NAV which can be in either USD or YEN. How do I add a calculation column in the report that reports =+Amount/Currency Factor and where do I put it so that it does not get erased each time the report is run?
Thanks!
1. You will need to have both fields in your table.
2. In the TableBuilder too, use "Add formula" to create a new column where you can create the necessary formula using the @[Field Name] for reference.
3. For example, you formula might be @[Amount]/@[Currency Factor].
4. Then rename the column in the Report Layout section of the TableBuilder.
Perfect! Your example helped me get my punctuation right. Thanks!! -d.