Groups Rendered Modification

[drv232Participant]

Is it possible to modify the group renderer function to display not only the total, but the sum of the product of two columns taken each row at a time.
Basically I want to use this function

                  aggregates: [
                        { 
                            'TOTAL': function (aggregatedValue, currentValue, column, record) 
                            {
                                    
                                var total = currentValue * record['Mark'];
                                sumOfProd=aggregatedValue + total;
                            } 
                        }
                    ] 

[ivailoParticipant]

Hi drv232,

It is possible.
Here is an exaple with added Sum.

Best Regards,
Ivailo Ivanov

jQWidgets Team
http://www.jqwidgets.com

[drv232Participant]

Hi ivailo,
Thank You for the example. I want to know if jqWidgets has any functionalities to calculate the weighted mean of two columns. I bought a licensed jqSuite but it does not give me the functionality. It would be great if you provided me with an example. I don’t see any products that seem to calculate the weighted mean. Thanks.

Dhaval Valotia,
Tiedemann Investment Group

[ivailoParticipant]

Hi drv232,

Every calculation can be customized. You only have to provide right formula/algorithm about your needed calculation + desired place for displaying the result.

Best Regards,
Ivailo Ivanov

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts