CalcFormula Property
Version: Available or changed with runtime version 1.0.
Sets the Calculation formula for a FlowField. The following syntax is valid for the CalcFormula property:
CalcFormula =
[-]Exist(<DestinationTable> [WHERE (<TableFilters>)]) |
Count(<DestinationTable> [WHERE (<TableFilters>)]) |
[-]Sum(<DestinationTable>.<DestinationFieldName> [WHERE(<TableFilters>)])|
[-]Average(<DestinationTable>.<DestinationFieldName> [WHERE(<TableFilters>)]) |
Min(<DestinationTable>.<DestinationFieldName> [WHERE(<TableFilters>)]) |
Max(<DestinationTable>.<DestinationFieldName> [WHERE(<TableFilters>)]) |
Lookup(<DestinationTable>.<DestinationFieldName> [WHERE(<TableFilters>)])
<TableFilters> ::= <TableFilter> {,<TableFilter>}
<TableFilter> ::=
<DestinationFieldName> = CONST(<FieldConst>) | FILTER(<Filter>) | FIELD(<SourceFieldName>) | FIELD(UPPERLIMIT(<SourceFieldName>)) |
FIELD(FILTER(<SourceFieldName>)) | FIELD(UPPERLIMIT(FILTER(<SourceFieldName>)))
Applies to
- Table field
Syntax
CalcFormula = Count(RecordCalcFields);
Remarks
Parts of the formula are described in the following table.
| Symbol | Description |
|---|---|
<DestinationTable> |
Specifies the destination table holding the information to be used in the FlowField. |
<DestinationFieldName> |
Specifies the destination field name. |
<TableFilters> |
A list of filters to be used in the computation of the FlowField. |
<TableFilter> |
A table filter can be one of the following: a constant expression, a filter expression, a value from ordinary fields, or a FlowFilter field. A key for the other table must exist and include the fields used in the filters. |
<SourceFieldName> |
Specifies the source field name. |
<Filter> |
A filter expression such as 10|20..30. |
You can choose from several methods of calculations including sum (total), average, maximum value, minimum value, record count, lookup, and whether a record exists. For more information, see Creating FlowFields and FlowFilters, FlowFields overview, and FlowFilter overview.