Skip to main content

Solutions

Products

Recommended products

Questions? We are here to help.
Contact us

Purchase

Questions? We are here to help.

Resources

Custom Formats

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.
tip
If you need a calculated field, but 1 or more of the fields in the calculation don't appear on the format and you don't want them to appear on the format, you can add them anywhere in the format and then make them invisible by setting the
Visible
 property in the Behavior section of the Properties pane for the fields to
False
.

This article applies to:

  • PRODUCT: Practice CS