Hi all,
I have a wingrid with two columns and I wanted one of the summary of one of them to be the sum of the items contained in column 1 divided by the sum of the items contained in column 2. Is that possible somehow?
thx
Sure. Create a summary and set the Formula to something like this:
"sum([Column 1]) / sum([Column 2])"
That is not working....
Here is my code below.... i couldn't get two columns working... so i tried taking it down to one... still no luck.... what am i doing wrong??
// Add summary rows
UltraGridBand band = UltraGrid1.DisplayLayout.Bands[0];
band.Summaries.Clear();
layout.Override.SummaryDisplayArea = SummaryDisplayAreas.HideDataRowFooters | SummaryDisplayAreas.GroupByRowsFooter | SummaryDisplayAreas.TopFixed;
band.Summaries.Add("sum([YTDDollars])", SummaryPosition.UseSummaryPositionColumn, band.Columns["YTDSellThru"]);
i figured it out.... i did not have a CalcManager on the form, and it wasn't set in UltraGrid.CalcManager... after setting these... the formula worked perfectly.... :)