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.
Help with Grade Formula
+27Adjust 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.
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.