Hi all,
Can I have your idea how to calculate the values from footer? Eg:
Can Anybody help ?. Is there a way by which i can get the individual values of footer in webgrid ? . As i need to use the values in different calculations. Any Information regarding this will be greatly appreciated.
For eg :- The logic i am using to create footer :-
For i = 0 To columns.Length - 1 With grid '.Columns(columns(i)).Footer.Total = Infragistics.WebUI.UltraWebGrid.SummaryInfo.Sum .Columns(columns(i)).Footer.Total = calculation .Columns(columns(i)).Footer.Style.HorizontalAlign = HorizontalAlign.Right .Columns(columns(i)).Footer.Style.CssClass = cssFooter .Columns(columns(i)).Footer.Style.Font.Bold = True End With
Next
I need a way to retrieve the individual calculated values of footer, to use them in a different place.
TIA
What I need to do is a bit different.
I need to format the result of the total formulas on my grid footers, but can't see how that would work:mygrid.Bands[0].Columns.FromKey("BILLINGS_AMT").Footer.Formula = "ROUND(SUM([Total]),0)"; What I need to be able to do is apply formatting to that resulting total, similar to what I do here on the cells of that column:e.Row.Cells.FromKey("BILLINGS_AMT").Text = CultureFormatting.FormatNumber(Double.Parse(e.Row.Cells.FromKey("BILLINGS_AMT").Text), 0, CultureInfo.CurrentCulture);
I need to get to the value produced by the formula and apply culture aware formatting to it.
Please see following link -
http://news.infragistics.com/forums/p/3557/18723.aspx#18723
This meight be help you.
Good luck....
Hi,
I want to calculate the values from footer as above screenshot.
Eg: (46352 / 47192 )* 100 =xx.xx and put the values into next columns......
To calculate values from footer , you have to set formula using following -
UltraGrid1.Columns.fromKey("Salary").Footer.Total = SummaryInfo.Avg;