ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: vijay@spinetechnologies on November 30, 2021, 11:28:31 am

Title: Need Time Based Sum In Aggregate Function
Post by: vijay@spinetechnologies on November 30, 2021, 11:28:31 am

I would like to calculate Sum of time in (hh.MM) format

Work Hours
10.30
01.45
02.30

Total Work Hours : 14.45

How I can achieve it. Kindly guide us

Title: Re: Need Time Based Sum In Aggregate Function
Post by: paramvir on November 30, 2021, 03:43:51 pm

You would need to write a custom aggregate.

Here is the example of custom aggregate: https://paramquery.com/pro/demos/group_rows_custom_summary

Code: [Select]

agg.sumdate = function(arr){
//arr is array ['10.30', '01.45', '02.30']
arr.forEach(function(val){

});
return sum_of_hr_and_min;
}

Please let me know if you need help with logic of the method.