PivotField.StandardFormula Property

Syntax

expression.StandardFormula

expression A variable that represents a PivotField object.

Remarks

The StandardFormula property primarily affects item names with date or number formatting. It provides a way to specify or query a formula for a given calculated item.

The StandardFormula property is "international-friendly" whereas the Formula property is not.

Example

This example adds 10 to the Decimals field and displays it as a calculated item in the data field. The example assumes that a PivotTable exists on the active worksheet and that a field titled "Decimals" exists in the data table.

Sub UseStandardFomula() Dim pvtTable As PivotTable Set pvtTable = ActiveSheet.PivotTables(1) ' Change calculated field of decimals by adding '10'. pvtTable.CalculatedFields.Item(1).StandardFormula = "Decimals + 10" End Sub

See also:

• PivotField Object
• PivotField Object Members