Adding computed fields to a DataWindow object
You can use computed fields in any band of the DataWindow object.
Typical uses with examples include:
-
Calculations based on column
data that change for each retrieved rowIf 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 functionsToday()andNow()in
computed fields.