"The value entered does not match the format of the field" with no division
- February 20, 2023
- 1 reply
- 1981 views
I am a lawyer trying to make a contract that auto populates off a cover sheet. I am not dividing by zero, yet I am getting the "The value entered does not match the format of the field []" error on fields with simple notation like this (I do not know java, use value dropdown or simplified field notation):
Input = A, B, C, D
Dropdown = E [value for choice E1 is 0.9 / choice E2 is 0.85]
Calculated = 1 [Product (x) of A, E], 2 [minimum of 1, B], 3 [notation of ((A+C)*E)-2], 4 [minimum of 3, D], 5 [notation of (((A+C)*E)-2)-4], 6 [notation of 5/"12"]
If I input the following values A=4288, B=4769, C=0, D=0, E=E1, by the time I enter D (I usually do the dropdown first), I get the following errors:
"The value entered does not match the format of the field [ 3 ]"...
Immediately followed by
"The value entered does not match the format of the field [ 5 ]"...
Immediately followed by
"The value entered does not match the format of the field [ 6 ]", plus...
It gives me the same (but wrong) value for 3 and 5, usually the value 1.
And yes, I made sure the field calculation order goes 1, 2, 3, 4, 5, 6....
Any help would be appreciated. Thanks to everyone in advance!
I added an example of the problem, for it, input the following values 2022 Available=4288, 2022 Anticipated=4769, 2021 Available=0, 2021 Anticipated=0, Client Type (First Box)=Standard
