PivotGridOptionsData.OptimizeSummaryTypeCalculation Property

Gets or sets whether to use decimal type conversion while calculating data in certain aggregation types.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v20.1.Core.dll

Declaration

[DefaultValue(true)]
[PropertyCategory(PropertyCategory.ClientMode)]
public bool OptimizeSummaryTypeCalculation { get; set; }
<PropertyCategory(PropertyCategory.ClientMode)>
<DefaultValue(True)>
Public Property OptimizeSummaryTypeCalculation As Boolean

Property Value

Type Default Description
Boolean

true

True, if the optimized calculation mode is switched on; otherwise, false.

Property Paths

You can access this nested property as listed below:

Library Object Type Path to OptimizeSummaryTypeCalculation
WinForms Controls PivotGridControl
.OptionsData.OptimizeSummaryTypeCalculation
ASP.NET Controls and MVC Extensions ASPxPivotGrid
.OptionsData.OptimizeSummaryTypeCalculation
MVCxPivotGrid
.OptionsData.OptimizeSummaryTypeCalculation
PivotGridSettings
.OptionsData.OptimizeSummaryTypeCalculation
Reporting XRPivotGrid
.OptionsData.OptimizeSummaryTypeCalculation

Remarks

IMPORTANT

If you notice loss of precision in calculation results for several aggregation types, turn off the optimized calculation mode by setting the OptimizeSummaryTypeCalculation property to false.

The optimized calculation mode provides improved performance by excluding unnecessary type conversions for source data during aggregations. Although we tend to maintain backward compatibility in return data types and precision, there might be certain issues which you can avoid by setting the OptimizeSummaryTypeCalculation property to false.

The Legacy (PivotDataProcessingEngine.Legacy) engine converts all values to the Decimal type and subsequently calculates the summary values. This operation is time consuming, thus in the optimized engine summary values are calculated using the original type. Decimal operations yield higher precision, so you may wish to enable decimal conversion in LegacyOptimized mode (PivotDataProcessingEngine.LegacyOptimized) by setting the OptimizeSummaryTypeCalculation property to false.

See Also