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
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})
To Avoid that error, You Must change Column Type to Decimal.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |