summation of date interval.

[#1]

Hello Team,

I have two dates date1 and date2, I am finding difference between the two dates using interval function in an expression of straight table

Here I want the sum of whole expression.

my expression is

if(condition,interval(sum(date2-date1),'hh:mm','00:00')

which giving me difference in hours and minutes along with this I am able to find sum of the expression but in few cases where condition won't satisfy my expression will take '00:00' , in this cases the total sum of expression is not displaying.

Can someone suggest me the solution for this.

Thanks!!!

[sasiparupudi1]

Try may be

sum(if(condition,interval(date2-date1,'s'),0))

[#3 · Accepted solution]

Thanks all for your support ,

It got resolved by changing "Expression Total' to "Sum Of Rows" option in expression tab of straight table.