Hi,
I have a sum of a list of durations and a count of how many rows.
Could do with an accurate average but my calculation is rounding the numbers??
[list of durations] (Duration)= 0:11:10
sum(
select(
Element Timings[Duration],
[Element_id]=[_THISROW].[Element_id]))
[count of elements] (Number) = 4
count(
select(
Element Timings[Element_id],
[Element_id]=[_THISROW].[Element_id]))
My calculation
[Average] (Decimal) =
totalseconds([list of durations])/[count of element]/60
The result = 02.00
where really I could do with it being more accurate as: 00:02:48
Would any of the Appsheet gurus have any ideas?
Best,
Chris.
User | Count |
---|---|
43 | |
27 | |
24 | |
22 | |
13 |