Hi There
I need to implement a weighted Average Calculation in the group of the Grid, can you tell me if there any way I can implement this, as the functions define are not helping. I have tried this but it will not work
// string s_test = "Sum(YieldPrice * ProjectedBal) / Sum(ProjectedBal)";
// Item3 = new GridViewSummaryItem("YieldPrice", "WAVG : {0}", s_test);
// NewSummaryRowItem.Add(Item3);
string s_test = "Sum(YieldPrice * ProjectedBal) / Sum(ProjectedBal)";
Item3 = new GridViewSummaryItem("YieldPrice", "WAVG : {0}", s_test);
NewSummaryRowItem.Add(Item3);
I have two columns YieldPrice and ProjectedBal I want to take the Sum(YieldPrice * ProjectedBal) per row which works fine, and divide by the Sum(ProjectedBal) column
Regards
Bugsy
// string s_test = "Sum(YieldPrice * ProjectedBal) / Sum(ProjectedBal)";
// Item3 = new GridViewSummaryItem("YieldPrice", "WAVG : {0}", s_test);
// NewSummaryRowItem.Add(Item3);