Help with Grade Formula

Topic Labels: Formulas
1051 3
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I am putting together a base for some schoolwork. I have a field for Points possible and points earned. Then I have a formula field with the following formula to calculate the grade percentage (Earned/Points*100) displayed as an integer. My problem is that not all assignments are graded so the ones that are not come up with NaN. Is there any workaround that would just leave it blank or 0. Thanks for any help you can offer.

3 Replies 3

Adjust your formula like so:

IF({Points Earned}, ({Points Earned}/{Points Possible}*100), 0)

If you want the field to be blank, remove the “,0” from the formula above.

It does not seem to be working. I have the following based on the actual field names IF(Earned), (Earned/Points*100), 0). The ones i used above was an example of what i was trying to do.

4 - Data Explorer
4 - Data Explorer

Nevermind, I figured it out. Thanks so much