Hello,
I have a XamDataGrid with fields/columns A, B and C. A and B are using summary definitions each with the default "Sum"-summary calculator set. For C I defined a third summary definition with a custom summary calculator where in the EndCalculation event I'am calculating a percentage value depending on the summaries A and B. The problem is, that I only can set one field as SourceFieldName per summary definition which I set to field C for the custom summary calculator. Now the EndCalculation event is just fired on changes of cells in field C. But I need it to be fired on changes of the cells in column A and B or just on their summary changes. How can I achieve this?
thanks for the hint. Using XamCalculationManager for summary calculations is a new feature of NetAdvantage 2012.2, right?! I tried it but the problem is it worked just for the grand summaries but not for the underlying group summaries. Am I missing something? See my code snippet of the 3 summary definitions I use:
<igDP:SummaryDefinition Key="Net2Summary"
SourceFieldName="Net2"
Calculator="Sum">
<igDP:SummaryDefinition.CalculationSettings>
<igDP:SummaryCalculationSettings ReferenceId="Net2Sum"/>
igDP:SummaryDefinition.CalculationSettings>
igDP:SummaryDefinition>
<igDP:SummaryDefinition Key="Gross3Summary"
SourceFieldName="Gross3"
<igDP:SummaryCalculationSettings ReferenceId="Gross3Sum"/>
<igDP:SummaryDefinition Key="PayfactorNet2Summary"
SourceFieldName="PayfactorNet2InPercent">
<igDP:SummaryCalculationSettings Formula="[Net2Sum] + [Gross3Sum]" ReferenceId="PFN2Sum"/>
I have been looking into your question and I can suggest you use our XamCalculationManager in order to create custom summaries based on field values :
http://help.infragistics.com/Help/NetAdvantage/WPF/2012.2/CLR4.0/html/xamCalculationManager_Using_xamCalculationManager_with_xamDataGrid.html
If you need any further assistance on this matter, feel free to ask.