One last thing.
I input the custom format script into the overal GPA field, and that fixed the multiplying by 100 issue.
I would also like to limit the number of decmils places to 2.
This RegExp will only allow a number with a decimal point and up to two decimal digits:
You can use it in your custom keystroke code to validate the entered value, and then use a format code to add the percentage symbol.
I placed that code in the custom keystroke like you suggested, but it did not work. Is there a specific way I need to input that code in the custom keystroke area?
I then tried to put it in the document level code and replaced (
/\d*/, val)with your code... that really screwed thing up.
So now I am stuck where I was before.
I will try and show you what I am trying to accomplish:
Right now, this is what is happening
Exam 1 Exam 2 Exam 3 Final Average 95.5% 95.3% 94.3% 95.033333%
What I would like to do is to limit each field to 2 decmil places.
Each "exam field" has the following:
The "final average" field has the following:
and this is in the custom calculations area of the "final average" field:
I have a feeling this is an easy fix, but I just cannot figure it out.
I don't see the regeular expression I created for you in any of those scripts. Also, there's no need to use a formatting script for a field that has a calculated value. You can simply add the percentage symbol in that calculation script.
If you wish, send me the file to try6767 at gmail dot com and I'll see what's not working well...