please help with the calculation i need if the duration is more than 1 and half minute then it should be considered as 3 and less than that should be consider as 1.

Hi @Suresh Pusuluri​,

your [Duration] is calculated as the difference from two dates, so it is a number that represents the number of days.

You can create a new field to do what you need:

//[New Field]
IF [Duration]>1.5/60/24 THEN 3 ELSE 1 END
 
// 1.5/60/24 is 1.5 minutes converted to days.

This work if you want to compare duration to 1.5 minutes row by row and the aggregate.

If you want, instead, to aggregate duration first, you need to change the above formula as follows:

//[New Field]
IF SUM([Duration])>1.5/60/24 THEN 3 ELSE 1 END

I hope this helps.

Regards,

Paolo