cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cooper33
Level 8

Calculate SP list average using filter?

I am trying to calculate the average value of a choice (single) column in a SharePoint list where a different choice (single) column is equal to a certain value (Get average Hours for employees in Chicago). In the OnStart of my app, I am binding my list to a collection:

ClearCollect(RecordsCollection, Employees)

This is the only formula I've gotten to work with no errors, however the value is incorrect (displays ~3000, should be <2)

Average(Filter(RecordsCollection, 'Chicago' = Region.Value), Hours.Value)

Hours is the choice column that I'd like to get the average of. I'm not finding a ton of forums on Average, does anyone see problems with this?

1 ACCEPTED SOLUTION

Accepted Solutions
cooper33
Level 8

Re: Calculate SP list average using filter?

The forumla above was correct. However once I changed the width of the label I was displaying this on to make it wider, the correct value appeared

View solution in original post

1 REPLY 1
cooper33
Level 8

Re: Calculate SP list average using filter?

The forumla above was correct. However once I changed the width of the label I was displaying this on to make it wider, the correct value appeared

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,515)