Add a field that references other fields to a custom format

When creating a custom format, you might need to add a field that isn't in the database but a calculation between 2 or more fields that also appear on the format.
The general format for a field that calculates 2 or more fields is:
={Section name.Field name} <operator> {Section name.Field name}
  • As an example, the formula for the
    Total Billed Amount
    on the detail line of the
    Billing Analysis
    report is:
    ={GroupFooter4.Detail_BilledAmount} + {GroupFooter4.Detail_ProgressBill}
    which translates to:
    Billed Amount field in the GroupFooter4 section plus the Progress Billed Amount field.
The
Section Name
is the name of the section in which the field resides.
The
Field Name
is found in the
General
section of the Properties pane. The Field Name needs to be entered in the formula exactly as shown in the properties.