Skip to content

Latest commit

 

History

History
85 lines (61 loc) · 3.26 KB

Totals.md

File metadata and controls

85 lines (61 loc) · 3.26 KB

Blazor WASM with local data

Totals

Index

You can enable the totals option for each column of your grid.

You can enable total's calculation for each column of a grid using the Sum, Average, Max and/or Min methods for the Column object:

    Columns.Add(o => o.Freight).Titled("Freight").Sum(true).Average(true, c => c.AverageValue.Number != 100 ? "red" : "");
  • Sum method works only for number columns
  • Average method works only for number columns
  • Max method works for number, date-time and text columns
  • Min method works for number, date-time and text columns

Methods

The parameters of the Sum method are:

Parameter Type Description
enable bool enable sum calculation on column
cssSumClass (optional) Func<ITotalsColumn, string> function to add CSS class to the total cell

The parameters of the Average method are:

Parameter Type Description
enable bool enable average calculation on column
cssAverageClass (optional) Func<ITotalsColumn, string> function to add CSS class to the total cell

The parameters of the Max method are:

Parameter Type Description
enable bool enable max calculation on column
cssMaxClass (optional) Func<ITotalsColumn, string> function to add CSS class to the total cell

The parameters of the Min method are:

Parameter Type Description
enable bool enable min calculation on column
cssMinClass (optional) Func<ITotalsColumn, string> function to add CSS class to the total cell

Calculated totals

It is possible to configure calculated totals based on other totals. They can be added to existing columns or to new ones. In both cases, columns must be named.

You can enable calculated totals for each column of a grid using the Calculate method for the Column object:

    Columns.Add(o => o.Freight).Titled("Freight").Sum(true).Average(true)
        .Calculate("Average 2", x => x.Get("Freight").SumValue.Number / x.Grid.ItemsCount, c => c.SumValue.Number != 100 ? "red" : "")
        .Calculate("Average 3", x => x.Get("Freight").SumValue.Number / x.Get("OrderID").SumValue.Number);;

The parameters of the Calculate method are:

Parameter Type Description
name string label of the total
calculation Func<IGridColumnCollection, object> function to calculate the total
cssCalculationClass (optional) Func<ITotalsColumn, string> function to add CSS class to the total cell

The function to calculted the total has only one parameter, the grid column collection.

This parameter includes a reference to the Grid, so you can use any Grid attribute as the number of records.

You can also get any column using the Get method. So you can include any column total using the following properties of the columns:

  • SumValue
  • AverageValue
  • MaxValue
  • MinValue

These properties contain the total values in one of the following attributes, depending on the type of column:

  • Number
  • DateTime
  • String

You can also use any other variable of the page in calculation function.

<- Custom columns | Sorting ->