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: