Aggregate Function / String Input

[Morgan]

So I am trying to get some Time values aggregated and I know what I have to get that value and do the math on that but I don't see the simple solution to getting the appropriate setup for the DataGridView with a custom aggregate function.  How would I take a value in this form: hh:mm:ss (ss are actually tracked) change it (ivalueconverter?) for the aggregation and then spit out a decimal format total?

I am completely buffaloed as to the method signature that is necessary to stop getting:

No generic method 'Sum' on type 'System.Linq.Enumerable' is compatible with the supplied type arguments and arguments. No type arguments should be provided if the method is non-generic.

[Vlad]

Hello,

 Can you sum your values with a normal LINQ query? 

Kind regards,
Vlad
the Telerik team

[Morgan]

So I had create a custom aggregator and do a summation of the minutes and hours of the field in question.  The field contains a date with the total hours & minutes (pay ammount) in date time format, easy for me to do date math for a aviation regulations.

The custom aggregator was hardcoded with type that the rows represent...

[Pavel Pavlov]

Hi Morgan,

Since custom aggregates are a bit tricky I may offer an easier to implement and debug approach - Generic aggregate function. I am attaching a small sample of generic aggregate function with custom sum logic.

I believe with the proper Linq expression using the approach from this sample you can achieve what you are trying.

In case you have troubles adapting this to your scenario , just let me know ( pasting some c# of your objects as well).

Kind regards,
Pavel Pavlov
the Telerik team

[Morgan]

i got this figured out, I just went back into my db, converted all the values that were stored as time and converted them all to double type.  This has solved my problem.

Thanks.