Calculated Fields in the Report Workspace

Calculated Fields in the Report Workspace

A calculated field is a field you can add to a custom report in the Report Workspace that performs a calculation on each person in the report.

To use a calculated field:

  1. Go to the Reports Workspace.
  2. Create a new report or edit an existing one..
  3. Click Add Calculated Field.
  4. Type a name into the Field Name field.
  5. Copy a formula below into the Formula field, or use the functions on the screen to create your own.
  6. Click Validate. Then click Apply. If validate gave you a message in red text below the formula, correct the errors it indicates before clicking apply.

Calculated Field Formulas

Name

Description

Formula

Age

Calculates a Contact’s age

YEAR(TODAY()) - YEAR('Date of Birth') - IF((MONTH(TODAY()) >= MONTH('Date of Birth')) AND (DAY(TODAY()) >= DAY('Date of Birth')), 0, 1)

Days Until Target

Calculates how many days until the Next Touch Date

DATEDIFF(“Day”,’Next TouchDate’,TODAY() )


    • Related Articles

    • How To Edit Custom Fields in G5

      Navigate to the Customizations Workspace, and go to the Custom Fields tab. Click the Edit button on the Custom Field you want to make changes to. Make any changes you need to, then click OK when finished.
    • Report Fields

      Fields are the basic building block of ad hoc reports. Each field represents an attribute that you want to view in the report. You can select fields in the Details tab in the Report Builder. Conduct a direct search for fields by entering the field ...
    • Opportunity Workspace

      Opportunity Workspace The Opportunity Workspace lists all the opportunities you have access to. You can use this workspace to review opportunities, manage activities associated with your opportunities, and create new and edit existing opportunities. ...
    • Reports workspace

      The Reports workspace lists all the ad hoc reports you have access to, and all the dashboards that you created. Use this workspace to view, add, edit, or delete reports and dashboards. The Reports workspace consists of the My Reports, All Reports, My ...
    • Report Builder

      Use the Report Builder to define or edit a report. Launch the Report Builder by clicking the Add Report button   on the top right of the Reports data table or by clicking the Edit Report button   for an existing report. The Report Builder displays a ...