Summary Operands Asp.Net MVC Helper (.net core)

Hi There,

I’m using the Summary feature of the grid, but i just want to display the Sum operand, not all of the values.

How can i go about doing this? IT’s a basic sum operation on the grid fields. Can i override the summary displays to include just the Sum total?

Here’s the code snipped in cshtml

features.Summaries().Type(OpType.Local).ColumnSettings(settings =>
{
settings.ColumnSetting().ColumnIndex(0).AllowSummaries(false);

});

Hello,

I have been looking into your question and to achieve your summary requirements, you must handle the ColumnSettings property of the summary feature.

features.Summaries().ShowSummariesButton(false).ShowDropDownButton(false).ColumnSettings(settings => { })

You can then perform different settings for each individual column. You will handle all columns of the number data type or only some of them according to your requirements with their column cases and you will handle the SummaryOperands property.

settings.ColumnSetting().ColumnKey("Salary").SummaryOperands(so => { })

With this property you can set only certain sum operands to be displayed in your grid for the specified column. By adding a SummaryOperand for the column and using the Type property you will pass the SummaryFunction.Sum operand and finally activate it with Active(true).

so.SummaryOperand().Type(SummaryFunction.Sum).Active(true);

This way you will enable only a certain summarization operand for a certain column.

features.Summaries().ShowSummariesButton(false).ShowDropDownButton(false).ColumnSettings(settings =>
{
          settings.ColumnSetting().ColumnKey("Salary").SummaryOperands(so =>

                     {
                             so.SummaryOperand().Type(SummaryFunction.Sum).Active(true);
                     });
})

The described scenario could be observed here:

 

In addition, I have prepared small sample illustrating this behavior which could be found attached here. Please test it on your side and let me know how it behaves.

If you require any further assistance on the matter, please let me know.

Regards,

Georgi Anastasov

Entry Level Software Developer

Infragistics

To display only the total sum in your GEPCO bill grid, modify the summary settings as indicated. This adjustment will show just the overall total, omitting the individual values for each row.