I apologize in advance for being a novice here, but I have a tight deadline (today), and my frustration with Acrobat is getting the best of me. Here's what I'm trying to do. I have a form with a grid of text fields that require the user to input 2 to 3-digit number. From those fields, I am trying to calculate the average value of all number entered, which works fine. I also want to calculate the Minimum and Maximum value, then divide the Maximum by the Minimum. Sounds simple enough.
So this is what I've done so far. Created the grid of text fields (about 80 fields total). These fields are formatted as None, since that is the default. I created another text field to use for calculating the Maximum. I used the Calculate tab and selected the "Value is the Maximum.." option at the top, then picked the correct text fields. I formatted this text field as a Number with 1 decimal place. I then did the same for Minimum. Both of these text fields need to be hidden on the form, so I selected the Hidden option for Visibility.
Next, I created another text field to divide the Maximum by the Minimum. The results here also have to be a number with one decimal place. I used simplified field notation with the field names for my minimum and maximum text fields, like this: Maximum/Minimum.
So when I save the form, and open, the form doesn't work. When I enter a number in the text field grid, I get an error message saying the format doesn't match the format of the field used to divide the maximum by the minimum. And in testing the form, I also don't see any values in the Minimum and Maximum fields when I make these visible and enter numbers in the grid.
And to make things worse, if I go back and redo the calculation fields, it appears to work, then after clearing and saving the form, it doesn't.
Any help would be greatly appreciated.
George Kaiser