Get aggregateColumn value

Hi,

I would like get % with this 2 values (created 2 aggregateColum). How to get this 2 values?



3 Replies 1 reply marked as answer

JP Jeevakanth Palaniappan Syncfusion Team June 8, 2021 07:42 AM UTC

Hi Ainhoa, 

Greeting from Syncfusion support. 

We have validated your query and you can achieve your requirement by using the Custom Aggregate feature of the grid. This will be used to customize the aggregate values based on your functionality. Please refer the below code snippet, sample and the documentation for your reference. 

    <GridAggregates> 
        <GridAggregate> 
            <GridAggregateColumns> 
                <GridAggregateColumn Field=@nameof(Order.Freight) Type="AggregateType.Sum" Format="C2"> 
                    <FooterTemplate> 
                        @{ 
                            var aggregate = (context as AggregateTemplateContext); 
                            <div> 
                                <p>Sum: @aggregate.Sum</p> 
                            </div> 
                        } 
                    </FooterTemplate> 
                </GridAggregateColumn> 
                <GridAggregateColumn Field=@nameof(Order.Freight1) Type="AggregateType.Sum" Format="C2"> 
                    <FooterTemplate> 
                        @{ 
                            var aggregate = (context as AggregateTemplateContext); 
                            <div> 
                                <p>Sum: @aggregate.Sum</p> 
                            </div> 
                        } 
                    </FooterTemplate> 
                </GridAggregateColumn> 
                <GridAggregateColumn Field=@nameof(Order.Freight2) Type="AggregateType.Custom"> 
                    <FooterTemplate> 
                        @{ 
                            <div> 
                                <p>@CalculateAggregate()</p> 
                            </div> 
                        } 
                    </FooterTemplate> 
                </GridAggregateColumn> 
            </GridAggregateColumns> 
        </GridAggregate> 
    </GridAggregates> 
 
@code{ 
 
    public int? CalculateAggregate() { 
        var Freight = Orders.Sum(Order => Order.Freight); 
        var Freight1 = Orders.Sum(Order => Order.Freight1); 
        return Freight % Freight1; 
    } 
} 



Please refer the below documentation for further reference. 

Regards, 
Jeevakanth SP. 


Marked as answer

AE Ainhoa Erkizia June 15, 2021 09:10 AM UTC

Problem solved. Thank you very much.



JP Jeevakanth Palaniappan Syncfusion Team June 16, 2021 05:20 AM UTC

Hi Ainhoa, 

You are most welcome. Please get back to us if you have any other queries. 

Regards, 
Jeevakanth SP. 


Loader.
Up arrow icon