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.
See also
Commentaires
https://aka.ms/ContentUserFeedback.
Prochainement : Tout au long de l'année 2024, nous supprimerons progressivement les GitHub Issues en tant que mécanisme de retour d'information pour le contenu et nous les remplacerons par un nouveau système de retour d'information. Pour plus d’informations, voir:Soumettre et afficher des commentaires pour