Displaying an Average of Data from a SharePoint List

(0) Share

Report

Posted on by LaingBennett

Hi there,

I have built the following chart which is control via a DROPDOWN menu.

The data table that this comes from looks like this.

What I want to do is get an average amount of the number of events. This would be a sum of the Total divide by the number of Years in the selected list.

I am using the following to try and get the total but it does not return a number.

Text(Sum(Filter('2020 - Sale Historical Data by Year' , Event = Historic_Data_DD.Selected.Value)

Also, I don't know where to begin to get it to divide by the count of rows.

Thanks

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@LaingBennett

Consider the following formula to resolve your average:

With({theData: Filter('2020 - Sale Historical Data by Year' , Event = Historic_Data_DD.Selected.Value)}, Text( Sum(theData, Total) / CountRows(theData) ) )

I hope this is helpful for you.
LaingBennett 84 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much - works perfectly.
LaingBennett 84 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry I forgot to mention how to you get the return value to round to a whole number? Currently it have 8 decimal places.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@LaingBennett

Use a format on your Text function:

With({theData: Filter('2020 - Sale Historical Data by Year' , Event = Historic_Data_DD.Selected.Value)}, Text( Sum(theData, Total) / CountRows(theData), "0.0" ) )

Note, the "0.0" will give you whole number and one decimal position. If you want no decimal, then change to "0"