Not quite.

Is there a way in which I can access the summary data of a column, and then use that to calculate the summary for another column.

summaryData(column3)=getAggregateData (column1)/getAggregateData (column2)

Hi Tony, Thank You for your reply. However, I have not been able to implement this. Is it possible to implement this using the $grid->setColProperty procedure?

Hey thanks a lot for your reply. My requirements are a bit different.

I have the following code

I need weighted means, so I’m calculating the sum of the product of Mark and MarketVal. This sum of the product is then divided by the sum of the MarketVal columns.

The value that I get after the division needs to go into the groupSummary Row in the Mark Column.

You can see that I am writing the values that I get on division into the log. This value is correct in the log. But it displays NaN when I return it. Can you help me how to go about this.

Also I have not used the formatter function, since I think it works without it.

It will be great if you help out since weighted means is something our company needs on a daily basis.

It would be great if you could place an example or just tell me what I am missing in my code, since you said I’m very close to my solution.

I think it’s just a matter of returning the appropriate value, since the console log shows me the right values.

I have looked into this but not found a solution as yet.

Thank You Will.

This is great. I got it working. Thanks a lot Will!!!