AVERAGE() Accuracy

Chris_Jeal
Participant V

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.

0 1 93
1 REPLY 1

Bahbus
Participant V

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.

Top Labels in this Space