Is it not possible to have a SUM of either a ...

(Katica Deusing) #1

Is it not possible to have a SUM of either a decimal type column or of a duration type column? I always get the error msg that it has to be a number. So how can I add up numbers from a table that look either like this: 2.5 + 2.25 + 2.0 or like this: 2:30:00 + 2:15:00 + 2:00:00

(Aleksi Alkio) #2

If you need to calculate durations you can do it like “002:00:00”+“002:00:00”+“002:15:00”. With decimals you can calculate like 2.5+2.5+2.0 or like SUM({2.5,2.5,2.0})

(Naveen N) #3

To Avoid that error, You Must change Column Type to Decimal.