To calculate values from footer , you have to set formula using following -

UltraGrid1.Columns.fromKey("Salary").Footer.Total = SummaryInfo.Avg;

 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......

 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.

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