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.
totalseconds([list of durations])
is a Number.
[count of element]
is a Number.
60
is a Number.
Any math with all Numbers will return a Number.
User | Count |
---|---|
63 | |
25 | |
14 | |
11 | |
6 |