3.2.3.1.8.1 Calculated Field Formulas

A calculated field formula defines calculations using the contents of fields in a PivotTable.

The only names a calculated field formula shall use are names of fields defined within the PivotTable the formula is used for.

A calculated field formula has the following form:

``` pivot-field-formula=
pivot-field-expression ;
pivot-field-expression=
{space}, pivot-nospace-field-expression, {space} ;
pivot-nospace-field-expression=
"(", pivot-field-expression, ")" |
pivot-constant |
prefix-operator, pivot-field-expression |
pivot-field-expression, pivot-infix-operator, pivot-field-expression |
pivot-field-expression, postfix-operator |
pivot-field-function-call |
pivot-field-name ;
pivot-constant=
constant – array-constant ;
pivot-infix-operator=
"^" | "*" | "/" | "+" | "-" | "&"|
"=" | "<>" | "<" | "<=" | ">" | ">=" ;
pivot-field-function-call=
pivot-function-name, "(", pivot-field-function-argument-list, ")" ;
pivot-field-function-argument-list =
[pivot-field-expression], { comma, pivot-field-function-argument-list} ;
pivot-function-name=
predefined-function-name - pivot-function-invalid-name;
pivot-function-invalid-name=
"GETPIVOTDATA" | "DCOUNT" | "DCOUNTA" | "DSUM" | "DAVERAGE" |
"DMIN" | "MAX" | "DPRODUCT" | "DSTDEV" | "DSTDEVP" | "DVAR" |
"DVARP" | "INDEX" | "RAND" | "NOW" | "AREAS" | "ROWS" | "COLUMNS" |
"OFFSET" | "CELL" | "INDIRECT" | "TODAY" | "INFO" | "RANDBETWEEN" ;
pivot-field-name=
name – pivot-invalid-name |
"’" [pivot-field-string-chars] "’" ;
pivot-invalid-name=
"All" | "Blank" ;
pivot-field-string-chars=
pivot-field-string-char, { pivot-field-string-chars} ;
pivot-field-string-char=
"’’" |
character - "’" ;
```
Show: