Grade column based on points column?

More
2 years 2 months ago - 2 years 2 months ago #10223 by pauhana658
Grade column based on points column? was created by pauhana658
I have a Total Points column. I want to create a Grade column based on the Total Points column. I have created a text-based Grade Type and I have created a Weighted Average calculation in the Grade column based on the Total Points column.

It doesn't work. No matter what the number in the Total Points column, the Grade is "F". Is there a way to base a text Grade in one column on a numeric value in another column?





Attachments:
Last edit: 2 years 2 months ago by pauhana658.

Please Log in or Create an account to join the conversation.

More
2 years 2 months ago #10231 by bert
Replied by bert on topic Grade column based on points column?
It works but only if properly configured.
The 'Total points' column is most likely wrong. Make sure the grade type is set to generic and its 'Max points' is properly set.
I'm assuming the Grade column is set to 100% of 'Total points' already
The following user(s) said Thank You: pauhana658

Please Log in or Create an account to join the conversation.

More
2 years 2 months ago #10235 by pauhana658
Replied by pauhana658 on topic Grade column based on points column?
Yep, that works! And yep, the problem was the Total Points column was not set to generic. Thanks!

Please Log in or Create an account to join the conversation.