Hello,
I need to have a sum calculation on my columns.
The summery menu shows only Maximum, Minimum and Count. The datatype of my bound data is string, but i have a ValueConverter, which converts the string to integer...so I guess I should have a sum operand.
I even tried to add the operand manually by setting:
column.SummaryColumnSettings.SummaryOperands.Add(new SumSummaryOperand());
What happens is that I actually see the sum operand in the summery menu, but nothing else (no max, min, count). When I choose sum it appears ""Sum=" in the summery row, but no calculation happens.
Any ideas to solve this are very welcome
Thanks
Enrico
Hi Enrico,
The Summaries work with the underlying data (in your case - with the string data), so what you're seeing is the expected behavior.
In order to display "Sum" in your case, you'll need to implement custom summary operand. I created a small sample with your scenario that demonstrates how to do this.
Note that if you modify the default summary operands collection, you'll need to add all summary operands you want to display. In other words, you'll have to add "Min", "Max" and "Count" along with your custom summary operand.
Hope that helps,
Thanks for your example, I could implement it in my solution.