Share via

Microsoft Lists - Average Score formula

Anonymous
2022-06-26T00:03:40+00:00

Hello Experts,

I am trying to get the average score but getting either %DVI something or %!VALUE or incorrect percentage.

Basically i have 12 parameters, each parameters has an options Yes , No and NA, if I select Yes i should get 100% and No is 25% while NA is no score but not zero then I need to get the total average score for the 12 parameters.

Thanks in advance for the help

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-07-12T17:48:00+00:00

    Do we have an update?

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-07-05T10:30:11+00:00

    Hello Tin,

    Do we have an update?

    Thanks

    Zoe

    Was this answer helpful?

    0 comments
  3. Anonymous
    2022-06-26T15:16:36+00:00

    Dear zoe price,

    Good day! Thank you for posting to Microsoft Community. We are happy to help you.

    According to your description, we understand that there are Yes/No columns in your List. You want to obtain the corresponding score according to the user's choice, and then calculate the average value.

    Please give us some time to investigate to see if we can help you with such a transition, thank you for your understanding.

    Sincerely,

    Tin | Microsoft Community Moderator

    ***Note: In the event that you're unable to reply to this thread, please ensure that your Email address is verified in the Community Website by clicking on Your Account Name > "My Profile" > "Edit Profile" > Add your Email Address > tick "Receive email notifications" checkbox > click on "Save".***

    •Beware of Scamm

    Was this answer helpful?

    0 comments