Advanced Report Writer (ARW) - How do I add formulas to a report?
Description

When you're designing an Advanced Report Writer (ARW) report, you can define a formula and use the values of other fields to perform calculations. All the usual arithmetical operators are available: Addition, subtraction multiplication and division. You must include the field names in your report that you've referenced in the formula, but they don't need to be visible in the report output.

Cause
Resolution
  1. Click Formula.
  2. In the Description box, enter a title for the formula (up to a maximum of 10 characters in length).
    You should give this formula field a meaningful heading, so that an informative title prints above the formula column.
  3. Click Show Available Fields, then select the fields you want to use in your formula and click OK.
  4. Add the necessary arithmetical operators, then click OK.

 


 

Live drop-in support sessions

Join us for a live drop-in Q&A session, where you can put your questions to our Sage experts. We'll then demo the most common questions you're asking us right now.
Join a session >

 

 

Steps to duplicate
Related Solutions