I have a ultragrid bound to a link data, it displays approximately 100 rows, the rows are like
(columns: rownumber, id, name, amt)
1. 1001 John $10
2. 1002 Bob $13
3. 1003 Kathy $90
1. 1004 David $23
2. 1005 George $84
3. 1006 Eric $83
and the row continues like this with 3 rows as a set.
Now i want the summary of 1's 2's 3's Amt sum like below
Summary:
1= $33
2=$97
3=$173
How can i do this, what formula i can use for this.
Are there a fixed number of row sets? If so and you know exactly how many there are, you could build a formula string that sums up the individual cells. But the formula would have to refer to each cell individually, so it would be a really long string and you would probably want to build the string in code.
If there are an indefinite number of set, then I don't think this is possible. There's no way for a formula to sum a column and only use some rows and not others... at least no built-in way. You could create your own custom function or use an ICustomSummaryCalculator to write code to do the sum yourself.
Unfortunately, the row sets are indefinite, could be between 100 to 200.
Even if i build a string formula by calculating individually, do i have to do that for every column, can you give me some example. (Amt column in my first post i given is just an example, i have atleast 25 different amt columns)
I tried the formula like the below:
SUM ( if([rownumber] = 1, [Amt],0) )
but the result are #VALUE, i believe there is a syntax error or may be something else.