Learn@UW - Checking for Un-graded Values in the Formula Editor

This document explains how to check for un-graded items in the Formula Editor used to compose Formula Grade Items.

It is often necessary to be able to distinguish between zero and un-graded (null) values when composing Grade formulas in the Formula Editor.

There is no direct way to test for a 'null' value if a value is un-graded.

However, you can check if a value is un-graded by checking if the Percentage or UserGrade value is not greater than or equal to zero.

For example, the following formula calculates the number of un-graded items among three grade items A1, A2, and A3:

Count of un-graded items

Keywords:brightspace learn@uw learnuw d2l desire2learn calculate check ungrade null grade formula editor item   Doc ID:6338
Owner:Susan D.Group:Learn@UW Utility
Created:2007-08-08 19:00 CDTUpdated:2015-06-03 16:08 CDT
Sites:DoIT Help Desk, DoIT Tech Store, Learn@UW Utility, My UW-Madison Portal
Feedback:  1   0