Unanswered

how to calculate the average between the choice 5 fields

(0) Share

Report

Posted on by BayanAlmoqati

i have 5 fields from choice type and contain list of numbers and one field calculate to calculate the average between the others 5 fields how i can do that ,Is this possible and what is the solution? using sharepoint list customize form

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Dee Ramos 47 on at

Like (0)

Report

Yes, it’s possible to calculate the average between the five choice fields in a SharePoint list form. I used this Power Fx:

((DataCardValue2.Selected.Value)+(DataCardValue3.Selected.Value)+(DataCardValue4.Selected.Value)+(DataCardValue5.Selected.Value)+(DataCardValue6.Selected.Value))/5

Here is how I set up the list:

I created the app and added the edit form. I connected the edit form to the SharePoint List. Within the form under advanced, I unlocked the Average DataCardValue. Mine was DataCardValue7.

When I unlocked the DataCardValue, I used this Power Fx in the Default:

((DataCardValue2.Selected.Value)+(DataCardValue3.Selected.Value)+(DataCardValue4.Selected.Value)+(DataCardValue5.Selected.Value)+(DataCardValue6.Selected.Value))/5

Was this reply helpful? Yes No
BayanAlmoqati 28 on at

Like (0)

Report

Thank you Ms @deeramos10 for answer me

i want to add text field to display recomendd if average greater than or equles 2.5 otherwise not recomended ,

but this formla give me error, what is the solution?

Was this reply helpful? Yes No