Welcome to the WPF feedback portal. We’re happy you’re here! If you have feedback on how to improve the WPF, we’d love to hear it!>
Thanks for joining our community and helping improve Syncfusion products!
The pivot grid control does not calculate the values properly based on the given formula in field header. This issue occurs if the field header values contains "or" text inside the formula. If any calculation header name contains 'or', the values are populated as 0 in the pivot grid control. This behavior need to be fixed.
For example,
PgSfOverview.PivotCalculations.Add(New
PivotComputationInfo With
{.FieldHeader = "% Theorie", .FieldName = "PercentTheorieKms", .CalculationName = "PercentTheorieKms", .CalculationType = CalculationType.Formula,*.Formula = "[Theorie Split Kms] / [Gereden Kms]",* .SummaryType = SummaryType.DoubleTotalSum, .Format = "##0.00 %"})