Adding computed fields to a DataWindow object – PB Docs 2017

Contents

Computed columns versus computed fields

Defining a computed field in the DataWindow painter Design
view

• Calculations based on column data that change for each
  retrieved row

  If you retrieve yearly salary, you can define a computed
  field in the detail band that displays monthly salary: Salary /
  12.

• Summary statistics of the data

  In a grouped DataWindow object, you can use a computed field
  to calculate the totals of a column, such as salary, for each
  group: sum (salary for group 1).

• Concatenated fields

  If you retrieve first name and last name, you can define a
  computed field that concatenates the values so they appear with
  only one space between them: Fname + ” ” + Lname.

• System information

  You can place the current date and time in a DataWindow
  object’s header using the built-in functions Today() and Now() in
  computed fields.