Help with Grade Formula

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.

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.

2 Likes

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.

Nevermind, I figured it out. Thanks so much