expression.StandardFormula
expression Required. An expression that returns one of the objects in the Applies To list.
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