One of the columns in SummaryBand looks like below;
12:30:14 (which means 12 hours 30 minutes 14 seconds)
11:36:45
1:22:18
The sum of the column should be 25:29:17.
I think I should set summaryType as Formula like....
summaryBand.Summaries.Add(
"TMinutes", SummaryType.Formula, summaryBand.Columns(fnMinute), SummaryPosition.UseSummaryPositionColumn)
But I have no idea how to set up the formula, can you help me?
Hi,
What's the DataType of the column?
The formula for this would look just like the formula for any other column sum. Something like this:
"SUM([column key])"
But this will only work if the data type of the column supports the addition (+) operator. If it does not, then another option would be to use SummaryType.Custom and create your own ICustomSummaryCalculator class.
It is the String with format of hh:mm:ss.
So SUM(Column Key) would not work.
THat's why I posted this issue.
Is there any samples of to use SummaryType.Custom and create your own ICustomSummaryCalculator class which will give me a clue how to solve this issue?