does anyone (here) have experience developing calcs in interactive adobe acrobat forms?
Posted by
amanda
Sep 7 '12, 11:08
|
I have a stupid problem.
I have this equation in a field named M1 that is based on MULTIPLE fields on the form:
M1 = ((E1+E2+E3+E4+E5+E6+E7+E8+E9+E10+E11+E12+E13+E14+E15+E16+E17+E18+E19+E20+E21+E22+E23+E24+E25+E26+E27+E28+E29+E30+E31)/K1)*100
when M1 is formatted as a numeric field, and data is entered into *each* of the fields involved, the resulting value is beautiful.
*until* you begin deleting data from the E and K fields (note that I discovered this while I was trying to check for errors in the form�s design). *then* the form begins beeping and showing an error window saying "the value entered does not match the format of the field M1." I suppose this makes sense.
I *have found a solution, but it's not workable, really -- when I remove the numeric formatting from M1, the form behaves. If Adobe thinks M1 is unformatted, all is great! but this gives me a ridiculous result (ex: M1=12.125739585987%)
so � my ultimate question is this: since the validation is apparently not an option when the field is not formatted, how do I get Adobe to only reveal *whole numbers between 0 and 100* in M1?
ideas?
|
Responses:
|