Answered

CALCULATING AVERAGES UPON FILTER SELECTION

(0) Share

Report

Posted on by chudson002

211

Customer Service data comes from SharePoint list. When list is filtered by Division, FY and/or Employee, need the average score to change at the top. The score of 4.8 if for the entire list, Text = Average(Customer, Resp). Need this to change upon selected dropdowns and/or search. So far (for one drop-down): If(ddDiv).Selected.Result = "Select Division", Average(Customer, Resp)

Any suggestions how the formula can be revised/completed to accommodate both dropdowns and search?

Screenshot 2020-10-14 101738.png

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@chudson002

Change your average to perform the average on the items in the Gallery.

Average(yourGallery.AllItems, Resp)

I hope this is helpful for you.

Was this reply helpful? Yes No
chudson002 211 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes Worked like a charm😊.
Thanks so much!

Was this reply helpful? Yes No
chudson002 211 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes

Thanks again for the assist. All numbers filter out great...just need help with the formatting.
For the individual ratings, formatted with: Text(ThisItem.Expect, "[$-en-US]0.00") and returns 2 decimals. i.e., 4.81 - perfect!
Trying to get the number 4.82312935 from the average formula to display 2 decimal as well.
When I tried to combine the above with your solution, and other combinations, I am getting errors all around.
Please advise.

Thanks again,
V/R
chduson002

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@chudson002

Can you let me know what kind of errors you are getting and what your formulas are that are producing the errors?

Was this reply helpful? Yes No
chudson002 211 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes
Below is the formula used.

Average(Monica1.AllItems, Resp, "[$-en-US]0.00")

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@chudson002

Consider changing your formula to the following:

Text(Average(Monica1.AllItems, Resp), "0.00")

Was this reply helpful? Yes No
chudson002 211 on at

Like
a
(1)

Report
Copy link

Link copied!

@RandyHayes

Worked!!!!

Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!

Was this reply helpful? Yes No