Recalculate (Method)

Applies To:

ChartSection object, (CubeQuery)QuerySection object, DataModelSection object, DashboardSection object, OLAPQuerySection object, PivotSection object, QuerySection object, ResultsSection object, Section object, TableSection object, ReportSection object

Description:

Forces a section to recalculate. This method is useful if you use variables in computed columns.

Syntax:

Expression.Recalculate()

Expression Required:

An expression that returns an object for the Results and Table sections

Example:

This example forces Results sections to recalculate their values:

ActiveDocument.Sections["Results"].Recalculate()