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.
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.
