Fullscreen Image

Use the Expression Builder

Use the Add Calculated Field button in the Fields group on the Design ribbon to create calculated field, such as formulas, and provide totals in reports. When you click this button, the VBScript Editor pop-up window opens.  Below are some basic functions that require the Calculated Field.

Create totals (Count of WO Numbers, Total Hours)

Summarized fields must be part of the report and placed into the report.

Fields are first identified and then called in a formula.

  1. Name the fields that you want to total with a unique identifier entered into the Text property field. This value should identify the intent or contents.  For example:

    • WOCount

    • CloseCmplt

  2. Click the Expression Field button and place the field on the report.

  3. Utilize any of the following items to develop the calculated field.

Group Totals

(Round ((([CloseCmplt]/[WOTotal]) * 100),2)) + "%"

Place in the GroupFooter. 

Rounds the results to 2 decimals

Counts

Count(WONumberCtl)

Place where needed.

Counts the WONumber.

Count based on another field.

Place where needed (footer is normal).

This example counts WONumber based on Status Code:

Count(WONumberCtl,( Status = "CMPLT" or Status = "CLOSE"))

Report Totals (displays percentage):  Place in Report Footer to provide a percentage of the two totals.

(Round ((([CloseCmpltAll]/[WOtotalAll]) * 100),2)) + "%"

From field for date parameters:  Place these in the page header:

("From " + ([StartDate]) + " to " + ([EndDate]))

Day Count (for Work Order days open):

DateDiff("d",datecreated, now())