[drv232Participant]

Thanks Dimitar.

[drv232Participant]

Is this functionality now available for the footer’s?

[drv232Participant]

Did you find a solution to this problem of yours ssp? I need this functionality as well!

[drv232Participant]

Hi Dimitar, can we now display aggregates in the separate rows.
I figured there might have been developments over two years. Thanks

[drv232Participant]

I created the following custom aggregate function that help’s me get the right weighted mean.

{ text: 'MarketVal', datafield: 'MarketVal',  cellsformat: 'F2',cellsalign: 'right', align: 'right',  width: 200 ,aggregates: [{'<b>Weighted Mean</b>':
                            function (aggregatedValue, currentValue, column, record) {
                               // counter=counter+1;
                                var total = currentValue * record['Mark'];
                                markSum=currentValue+markSum;
                                var yesMarketVal=markSum;
                                var yesP=aggregatedValue + total;
                               return ((yesP)/(yesMarketVal)+aggregatedValue);
                               
                            }
                      }]  }

However, once I do grouping or carry out a filter, it changes its value but gives a wrong answer altogether.

A bizzare thing happens as well. When I change the MarketVal column width, it changes the weighted mean value by itself.

Any help to tackle this issue?

[drv232Participant]

You can use aggregates: [‘sum’] in

{
                            text: 'Calc Hrs(G)',
                            datafield: 'calcWorkTime',
                            editable: false,
                            width: 100,
                            cellsalign: 'center',aggregates: ['sum']
        }

[drv232Participant]

Hi Dimitar,
it uses the generaterow() function. I don’t want to use static data. can you provide an example without using generate row

[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

[drv232Participant]

Hi ivailo, Thank You.
I managed to debug my program.

[drv232Participant]

Hi…Thanks for the code…Was really helpful..

Can you post the file in
<?php require VIEWS_PATH . '_templates/tabs.php'; ?>

I’m trying to create the function to add new rows by checking your code out…I believe I need this file as well if I’m not mistaken

[Author]

Posts