Guriddo » drv232's Replies

drv232

Guriddo

Forum Replies Created

Viewing 8 replies - 1 through 8 (of 8 total)

Author

Replies

July 23, 2015 at 9:32 pm in reply to: Customized Aggregate #124067

drv232

Participant

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

July 13, 2015 at 3:35 pm in reply to: Customized Aggregate #124044

drv232

Participant

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.

July 10, 2015 at 7:39 pm in reply to: Customized Aggregate #124035

drv232

Participant

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

I have the following code


$grid->setColProperty('Mark', array(
"summaryType"=>"js:function(value, name, record) {
if(typeof value === 'string'){
value = {ProductSum: 0, MarketValSum: 0 };
}
// perform summary
if(record['Mark']) {
value.ProductSum += parseFloat(record['Mark'])*parseFloat(record['MarketVal']);
}
if(record['MarketVal']) {
value.MarketValSum += parseFloat(record['MarketVal']);
}
//console.log(value.ProductSum/value.MarketValSum);
//console.log(value);

return value ;

//return (value.ProductSum/value.MarketValSum)

}"

$grid->setColProperty('Mark', array(

"summaryType"=>"js:function(value, name, record) {

if(typeof value === 'string'){

value = {ProductSum: 0, MarketValSum: 0 };

}

// perform summary

if(record['Mark']) {

value.ProductSum += parseFloat(record['Mark'])*parseFloat(record['MarketVal']);

}

if(record['MarketVal']) {

value.MarketValSum += parseFloat(record['MarketVal']);

}

//console.log(value.ProductSum/value.MarketValSum);

//console.log(value);

return value ;

//return (value.ProductSum/value.MarketValSum)

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.

July 9, 2015 at 9:23 pm in reply to: Customized Aggregate #124030

drv232

Participant

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?

June 26, 2015 at 7:11 pm in reply to: Columns reordering on the go #123960

drv232

Participant

Thank You Will

June 26, 2015 at 7:10 pm in reply to: Customized Aggregate #123959

drv232

Participant

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)

June 25, 2015 at 4:18 pm in reply to: Columns reordering on the go #123948

drv232